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.
Now you've decided you are using postgres and not mysql? If you posted in mysql by mistake previously, please go back there and delete your post.
yeah sorry, posted by mistake, didnt see the delete function at first.