Jump to content

Archived

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

SeenGee

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.

 

Thanks.

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.