Re: select query across multiple tables
| From: | jeffrey_n_Dyke at Keane dot com | Date: | Thu, 26 Aug 2004 23:45:03 +0000 |
| Subject: | Re: select query across multiple tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35908@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?
You're only getting the rows that are less then or equal to class.classID,
i think you want <> or not equal to.
HTH
Jeff