select query across multiple tables
| From: | Cole S. Ashcraft | Date: | Thu, 26 Aug 2004 22:27:32 +0000 |
| Subject: | select query across multiple tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35906@lists.php.net to get a copy of this message | ||
I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment.
Currently, I have 'select class.classID, class.classDesc from class, assignment where assignment.classID >= class.classID and assignment.assignmentID=$assidn'. $assidn is value of assignment.assignmentID.
When I do this query, I am missing a good chunk of records. What am I doing wrong?
Cole
--
This message has been scanned for viruses and
dangerous content by MailScanner on mail.ashcraftfamily.net, and is believed
to be clean.
Please report any deviance from this condition immediately to the AFN
Administrator at admin@ashcraftfamily.net