This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
postgres:copy_command [2013/07/26 20:31] mh |
postgres:copy_command [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 22: | Line 22: | ||
world-# select code, (select id from organisations where name = 'EU') from countries where name in (select state from membership_raw where eu = 'EU'); | world-# select code, (select id from organisations where name = 'EU') from countries where name in (select state from membership_raw where eu = 'EU'); | ||
+ | |||
+ | world=# select c.name, o.name from countries c join countries_x_organisations cxo | ||
+ | on cxo.code = c.code join organisations o on o.id = cxo.organisation_id; | ||
+ | |||
+ | </code> | ||