Re: Create a new table from records not joined in a left outer join

I have a query of a left outer join

CREATE TABLE table3

AS SELECT d.*, u.*

FROM  table1 d

LEFT OUTER JOIN table2 u

ON (d.id = u.sgno); 

What i would like to do within the same query is to be able to create a new table with all the records of table2 that are not joined to table1. 

CREATE TABLE table3

AS SELECT d.*, u.*

FROM  table2 u

LEFT OUTER JOIN table1 d

ON (d.id = u.sgno)

where  d.id  IS NULL;

Regards,

Jayadevan