Jump to content


This topic is now archived and is closed to further replies.


sgl question: join 5 tables

Recommended Posts

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.



Share this post

Link to post
Share on other sites

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]...

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.