>
>Because you have two separate joins to TANKS: T.Number and T.Grade
>
>Maybe if you show the table source (stripped for content of course) and
>attempt to explain what you are trying to accomplish. I have an idea what
>you are trying to do but I'm not very good at reading minds so I might be
>wrong. ;)
>
>When designing the database, T.TankID->N.TankID, and T.GradeID->G.GradeID,
>may have made your life much simpler (hindsight)
>
>Scott.

grr grr grr - it's an inherited DB. Otherwise I would have done it
differently. It is exactly because there are two joins. :-( But it is as
you have written : T.TankID->N.TankID, and T.GradeID->G.GradeID

Never mind, I have worked around it in the code.

Thanks

Tim


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