> Hi. > > On Mon, May 20, 2002 at 01:58:25PM -0400, > [EMAIL PROTECTED] 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? > > No. > > > 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! > > If you have indexes defined on the table, try CHECK TABLE to assure > that the indexes are working as expected.
Everything seems fine with CHECK TABLE. > Else, try to create a test case. I.e. try to create a minimal set of > SQL commands which will produce the strange behaviour in order to > enable us to verify the behaviour. > > Creating a test case will also help, if it should be an usage error, > as you will learn better what happens. I'm not sure what you mean; do you mean running more basic commands? I did a generic SELECT * from each table, and they come out just fine. Thanks for answering! :) -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
