Jump to content


Photo

sgl question: join 5 tables


  • Please log in to reply
1 reply to this topic

#1 SeenGee

SeenGee
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 09 May 2003 - 07:25 PM

i need to join together 5 tables in a psql database i have made. the problem is that i cant seem to find the correct sql to perform the join.
the tables i have are group, person, contacts, movements and treatments. group and person are connected by a group_id, established in group, each entry in the person table also has a group_id. the other tables are connected by person_number, established in person and a foreign key in all the other tables.
Would really appreciate some help.

Thanks.

#2 effigy

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

Posted 10 May 2003 - 02:18 PM

something like this?

SELECT [columns] from group, person, contacts, movements, treatments LEFT JOIN group ON group.group_id=person.group_id LEFT JOIN [tablename] ON [condition]...


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