select from multiple tables - Mailing list pgsql-novice

From e-letter
Subject select from multiple tables
Date
Msg-id CAET1fe7b6GxjzWAU7aKkVCbL=zLaNzq-OJyc4LCJ_OBoUjgwcg@mail.gmail.com
Whole thread Raw
Responses Re: select from multiple tables
List pgsql-novice
Readers,

A database has table1, table2, table3, table4 and each table has
columns of text and integers:

table1
text1, 10
text2, 20
text3, 30
text4, 40
text5, 50
text6, 60
text7, 70
text8, 80

table2
text1, 10
text2, 20

table3
text3, 30
text4, 40

table4
text5, 50

Is it possible to create a new table (table5) by creating a query that
selects rows that _both_ exist in table1 _and_ are not in any of the
preceding tables (table2, table3, table4)?

Thanks in advance.

pgsql-novice by date:

Previous
From: Ross Boylan
Date:
Subject: coalesce in plpgsql, and other style questions
Next
From: Steve Crawford
Date:
Subject: Re: select from multiple tables