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


[Non-text portions of this message have been removed]