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.
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.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
