JOIN по нескольким таблицам.

	select id, name, a.field1, b.field2, c.field3
	from
	people p left join a on (a.person_id = p id)
	left join b on (b.person_id = p.id)
	left join c on (c.person_id = p.id);

view raw gistfile1.sql hosted with ❤ by GitHub