select from multiple tables
От
e-letter
Тема
select from multiple tables
Дата
Msg-id
CAET1fe7b6GxjzWAU7aKkVCbL=zLaNzq-OJyc4LCJ_OBoUjgwcg@mail.gmail.com
Список
Дерево обсуждения
select from multiple tables e-letter <inpost@gmail.com>
Re: select from multiple tables Steve Crawford <scrawford@pinpointresearch.com>
Re: select from multiple tables Lew <noone@lewscanon.com>
Re: select from multiple tables Alessandro Gagliardi <alessandro@path.com>
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 по дате отправления
