Jump to content

Archived

This topic is now archived and is closed to further replies.

SeenGee

sql multi table select

Recommended Posts

i need to perform a select on 5 tables in a postgre 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

Share this post


Link to post
Share on other sites

why was this posted again? can you show us the table structures...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.