RE: RE: joinig tables(non-equal join)

2003-09-11 Thread Dan Greene
> 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

Re: joinig tables(non-equal join)

2003-09-11 Thread Bruce Feist
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

joinig tables(non-equal join)

2003-09-11 Thread xander xxx
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