> 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php