Can I show records from my SQL statement where records both have a match and
do NOT have a match. I'm having trouble with the syntax for "no matching
records" in a related table, my current SQL statment looks like this:
SELECT fid,Family_Last_Name,Phone FROM familytable,playertable WHERE
playertable.Family_ID = familytable.fid AND playertable.SportRegistered =
'0' GROUP BY fid ORDER BY Family_Last_Name ASC;
This works fine, but I also want to show Families with NO matching records
in the player field, which the above statement does not do.....
TIA,
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
---------------------------------------------------------------------
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
