Hi, I am going nuts! I am querying two databases which are very similar to find the differences between various tables.
These two tables are 15 rows and 14 rows respectively. Why does this work (finds all similar rows): select ddetails.name, ddata.name from dancedetails.coupletypes as ddetails, dancedata.couples as ddata where ddetails.name = ddata.name; +------------+------------+ | name | name | +------------+------------+ | 1 couple | 1 couple | | 2 couples | 2 couples | | 3 couples | 3 couples | ... +------------+------------+ 14 rows in set (0.00 sec) BUT not this (trying to find the different rows): select ddetails.name, ddata.name from dancedetails.coupletypes as ddetails, dancedata2.couples as ddata where ddetails.name != ddata.name; +------------+------------+ | name | name | +------------+------------+ | 2 couples | 1 couple | | 3 couples | 1 couple | | 4 couples | 1 couple | | 5 couples | 1 couple | | 6 couples | 1 couple | ... | 3 facing 3 | other | | | other | +------------+------------+ 196 rows in set (0.12 sec) --------------------------------------------------------------------- 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
