Re: SELECT

Use External joins

select table1.name,table1.phonenumber,table2.age from table1,table2 where table1.name=table2.name(+)

hth

Arnaud BLANCHET Received on Mon Jan 29 2001 - 05:53:38 CST