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
Hi all
with Mysql 3.23 I would like to find missing values in the following situation:
1) table boxes: describes kind of boxes differing by how many items I can put
in.
Primary key is BoxID
boxID + Places
A + 1
B + 3
C + 5
2) table car describes how I can put some boxes on a
