At 08:13 07/22/03, you wrote:

> >At 06:54 07/22/03, 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
>
>At 08:04 AM 22/07/2003 -0700, Scott Taylor wrote:
>
>
> >Because you have two separate joins to TANKS: T.Number and T.Grade
>
>No, that wouldn't cause duplicate rows. These are all inner joins, so it
>should give as many rows as there are rows in Tanks.

Hi heLen,

I believe you, only because I lack that much experience. So, then what
else could it be?

I think we need more info.

Scott.