No - they wouldn't (or at least, it is extremely unlikely that they would
have) have the same values for MSold (Money Sold) and LSold (Liters Sold)

I think it's the grade duplication happening.

Thanks

Tim

At 09:37 AM 23/07/2003 +0200, you wrote:

>Well, you do say that one tank can link to several nozzles. If a tank then
>links to two nozzles which have the same values for LSold and MSold, then
>they will appear to be duplicate records (since you do not select any
>unique number in nozzles). As for grades, they will automatically be
>duplicated for every tank having more than one nozzle.
>
>Set
>
>At 15:54 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
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003

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