<filter-fidder: sql, query> Hi,
Hope you don't mind me hassling you about this yet again. >> ... So you would need to run two queries, a LEFT JOIN and a >> RIGHT JOIN (or a LEFT JOIN with tables swapped) to get all >> results. > ... ... which is what I did in the end. except that on further checking it doesn't work! This works fine: SELECT dancedetails.dances.* FROM dancedetails.dances LEFT JOIN dancedata.dances ON dancedetails.dances.ddref=dancedata.dances.dkey WHERE dancedata.dances.dkey IS NULL; But this never finishes: SELECT dancedata.dances.* FROM dancedata.dances LEFT JOIN dancedetails.dances ON dancedata.dances.dkey=dancedetails.dances.ddref WHERE dancedetails.dances.ddref IS NULL; And I don't understand why, for the life of me. Donna (PS: and I *have* RTFM) --------------------------------------------------------------------- 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
