ok... I think this'll work...
select unique t1.* from table1 as t1 left outer join table2 as t2 on t2.name = t1.name where t2.name is null > -----Original Message----- > From: xander xxx [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 2:56 AM > To: 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 the > query. If i use "=" instead of "<>" i get all names in table1 that > appear in table2, then, How can i get the oposite? > Thanks, and please, forgive my bad english. > 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]