n Fox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 17, 2004 8:00 AM
Subject: [SQL] Left joins with multiple tables
> Hi, all.
>
> I've got a bit of a problem here. I have 4 tables - people, a, b, c (not
> the original names).
>
> For eac
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,
Hi, all.
I've got a bit of a problem here. I have 4 tables - people, a, b, c (not
the original names).
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.
Handling the first table (a) is easy:
sel
