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

Reply via email to