sql multi table select

[SeenGee]

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

[effigy]

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