Subject SQL Question
Author Tim Ledgerwood
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
T.Number = N.Tank
Grades G
T.Grade = G.Grade_Num
Order by T.Grade, G.Descrip

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