At 03:54 PM 22/07/2003 +0200, you wrote:

>Hi all,
>
>when I execute the following SQL, I get duplicates records. Anyone know why?
>
>There are 2 nozzles and 2 grades of fuel.
>
>SELECT T.Grade, G.Descrip,
>N.LSold as VolSold, N.MSold as MoneySold
>FROM Tanks T JOIN Nozzles N
>on
>T.Number = N.Tank
>JOIN
>Grades G
>ON
>T.Grade = G.Grade_Num
>Order by T.Grade, G.Descrip

There are 4 tanks?

heLen