Hi Colin,
Try
select id, name, a.field1, b.field2, c.field3
from
people p left outer join a on (a.person_id = p id)
left outer join b on (b.person_id = p.id)
left outer join c on (c.person_id = p.id);
HTH
Denis
- Original Message -
From: "Colin Fox" <[EM
On Sat, Jan 17, 2004 at 02:30:01AM +, Colin Fox wrote:
> For each person in the people table, they may or may not have a record in
> a, may or may not have a record in b, and may or may not have a record in
> c.
...
> But I'd like to be able to do something like:
>
> select
> id, name,
