Postgres Pro
Downloads
Home   >   mailing lists

Create a new table from records not joined in a left outer join - Mailing list pgsql-novice

From Sindile Bidla
Subject Create a new table from records not joined in a left outer join
Date
Msg-id CA+fb49Z9J86n+bUPBy0JYseULgdZv_ruBL439cLyRZmjhLWnyg@mail.gmail.com
Whole thread Raw
Responses Re: Create a new table from records not joined in a left outer join
List pgsql-novice
Tree view
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. 

pgsql-novice by date:

Previous
From: James David Smith
Date:
Subject: Interpolating Values
Next
From: Jayadevan M
Date:
Subject: Re: Create a new table from records not joined in a left outer join