|Subject||Re: [firebird-support] SQL Question|
At 03:54 PM 22/07/2003 +0200, you wrote:
>Hi all,There are 4 tanks?
>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
>T.Grade = G.Grade_Num
>Order by T.Grade, G.Descrip