Jump to content


Photo

sql multi table select


  • Please log in to reply
1 reply to this topic

#1 SeenGee

SeenGee
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 10 May 2003 - 08:35 PM

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

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 11 May 2003 - 04:49 AM

why was this posted again? can you show us the table structures...
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users