sql multi table select

[SeenGee]

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

[blindeddie]

use joins...not sure what database you are using, but refer to the corresponding Manual...

[SeenGee]

i'm using postgres, i've looked through the manual but i can t find what i need

[Sxooter]

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=queries-table-expressions.html