Big Problem

[Sadus]

Hi,

I have 2 tables : table1(name, lastname) and
table2(name,lastname,iduser) and I have to create a SQL command which
must do this :

If in the table1 I have :

name lastname
durand michael
dupond john

and in table2 :
name lastname iduser
durand michael toto
dupond john toto
durand michael tutu

I must have a result like this dupond,john,tutu because tutu have not
all the data from table1.

Thanks

 

[tlbroadbent]

Try this query.

Select table2.* From table2 Left Join table1
On table2.name=table1.name
And table2.lastname=table1.lastname
Where table1.name is null Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost