[PHP-DB] select query across multiple tables
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 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] select query across multiple tables
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
Re: [PHP-DB] select query across multiple tables
Thanks! It works Cole On Thu, 2004-08-26 at 16:45, [EMAIL PROTECTED] wrote: 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 -- 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 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
