sgl question: join 5 tables
Posted 09 May 2003 - 07:25 PM
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.
Posted 10 May 2003 - 02:18 PM
SELECT [columns] from group, person, contacts, movements, treatments LEFT JOIN group ON group.group_id=person.group_id LEFT JOIN [tablename] ON [condition]...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users