
May 10th, 2003, 07:19 PM
|
|
Contributing User
|
|
Join Date: Apr 2003
Posts: 347

Time spent in forums: 14 h 41 m 27 sec
Reputation Power: 11
|
|
|
sql multi table select
i need to perform a select on 5 tables in a postgres db, table a is linked to table b through an 'id' explicity created in a and linked as foreign key in b. table b creates a primary key 'number' which is declared as a foreign key in c, d and e. each number is related to an id from table a.
i want to perform a select that pulls from the database every column from every table for each instance of 'number'. in tables c d and e there may be multiple entries for each number.
Thanks
|