UNION or UNION ALL
| От | Abdul Wahab Dahalan |
|---|---|
| Тема | UNION or UNION ALL |
| Дата | |
| Msg-id | 3E4B5CC3.2C10E63A@mimos.my обсуждение |
| Список | pgsql-sql |
I've 3 tables A,B,C <br />records in table A like: <br /><u>id name</u><br />b1 abc <br />b2 xyz<br />b3 rst <p>records in table B like: <br /><u>id type</u><br />b1 logistics <br />b1 importer<br />b2 logistics <br />b3 logistics <br />b3 exporter <p>records in table C like: <br /><u>id offer title</u><br />b1 sell car <br />b1 buy car <br />b1 sell van <br />b2 sell car <p>How shoul I do a query so that I can get a result like <br />(The querywill be based on B.type ='logistics') <br /><u>id name offer</u><br />b1 abc sell <br />b1 abc buy <br />b1 abc sell <br />b2 xyz sell <br />b3 rst -- <p>Any help very much appricated
В списке pgsql-sql по дате отправления: