- Original Message -
From: "Richard Reina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 8:26 AM
Subject: left join question
> Is it possible to do two left joins involving three
> tables in one query?
>
> select a.id, a.amount FROM t1
> LEFT JOIN t2 ON (t
[snip]
Is it possible to do two left joins involving three
tables in one query?
select a.id, a.amount FROM t1
LEFT JOIN t2 ON (t1.id=t2.id)
then
LEFT JOIN t3 ON (t1.id=t3.id)
Is this even possible?
[/snip]
Yes, and the keys from table to table don't have to be the same, save
for each JOIN..
S
Hi.
On Fri 2002-07-19 at 11:15:00 -0400, [EMAIL PROTECTED] wrote:
> I have a table of members that includes a status flag and a history
> table of activities that includes a date. What I need is all members
> with a particular status and their activites (which may be none) for
> some date range.