Hi, I´m trying to join two tables with the follow statement
SELECT t1.name,t2.name FROM table1 t1,table2 t2 WHERE t1.name<>t2.name.
I supose the expected result must be the non-matching rows of both tables, but it´s not what I get. ¿What it´s wrong with that query?. I hope do you understand my doubt. Thanks in advanced.
I'm not sure what you mean by the "non-matching rows of both tables"... are you expecting to find all rows in each table that have no matches in the other? If so, this query won't do it -- for each row in t1, it will return every t2 row except for one (if any) which does not match the t1 row.
Bruce Feist
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
