Hey all, I can't seem to wrap my head around this, please see if you can help me out. I have 2 tables. One with some basic info but they are structured as follows.
info table: IDNum(PK) LName FName Title Deladd City State Zip codes table: IDNum (used only so that there could be a primary key :-/ ) info_IDNum(fk) code The code column in the codes table can contain multiple codes for each info_IDNum. I want to make a query where it shows all the info_IDNum results that DON'T have an entry in the codes.code = 13. Where I am having trouble is that there are multiple codes for any given IDNum. Please help, thanx Ryan __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php