> Subject: Re: RE: joinig tables(non-equal join)
>
>
> Yes, that´s exactly what i get, but that´s not what i want. I wanna
> get all nanes in table1 that don´t appear in table2, and all names in
> table2 that don´t appear in table1. That´s why i use "<>" in t
xander xxx wrote:
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
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 doub