> Guten Tag Donna Robinson, Hi 2u2 sir! and god bless your cotton socks.
> i hope this will help you.. ... it didn't but it gave me enough of a clue so that this did: select dancedetails.coupletypes.* from dancedetails.coupletypes left join dancedata2.couples on dancedetails.coupletypes.name=dancedata2.couples.name where dancedata2.couples.name is null; So tell me - why does a left join work where an inner join refused to? (have only been sql-ing for about 2 wks) Donna --------------------------------------------------------------------- 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
