|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
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.
Thank you.
__________________
FSBO (For Sale By Owner) Realty |
|
#3
|
|||
|
|||
|
yeah sorry, posted by mistake, didnt see the delete function at first.
|
![]() |
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > sql multi table select |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|