#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Posts
    347
    Rep Power
    11

    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. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    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.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Posts
    347
    Rep Power
    11
    yeah sorry, posted by mistake, didnt see the delete function at first.

IMN logo majestic logo threadwatch logo seochat tools logo