Shouldn't this come up with a list of names from each table that matches?
SELECT * FROM table1,table2 WHERE table1.name = table2.name;
Does anyone see anything wrong with this query? It keeps giving me an empty
set - but there definitely matches. I even did a LIKE instead of =, takes
longer, but comes out the same. I triple checked the data, and it is
*exactly* the same!
Help!
Thanks!
:)
-Mike
---------------------------------------------------------------------
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