some more).
Greetings
François
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: mardi, 20. septembre 2005 21:29
> To: RAPPAZ Francois
> Cc: mysql@lists.mysql.com
> Subject: Re: SQL to use left join and find missing values
>
> If you w
If you want to join a table more than once, you need to refer to it
AS something else.
select sum(PlaceNo)
from boxes
inner join car using (boxID)
inner join load using (TravelID)
left outer join load AS Load2 on car.BoxNo=Load2.BoxNo
Where load.TravelID=1 AND Load2.BoxNo is null
On Sep 20, 2