On Monday, 20. May 2002 19:58, SpyProductions Support Team wrote: > 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!
You should check your data again! Georg --------------------------------------------------------------------- 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