select from multiple tables

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: select from multiple tables
Date: 2012-06-12 18:16:24
Message-ID: CAET1fe7b6GxjzWAU7aKkVCbL=zLaNzq-OJyc4LCJ_OBoUjgwcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2012-06-12 20:04:03 Re: select from multiple tables
Previous Message Ross Boylan 2012-06-12 17:46:41 coalesce in plpgsql, and other style questions