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. Alex
Sent by Medscape Mail: Free Portable E-mail for Professionals on the Move http://www.medscape.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]