> If Address1 and Address1 are different, then I presume that
> they have different table names?
> What I think you need is to add 'AS Address3' and 'AS
> Address4' after the second to so that they can actually by
> accessed.
>
> Personally I would not be using the same field name for
> different data across tables in the same database, so you
> would have to have a good reason for confusing yourself?

Ah, I forgot about 'AS'. The duplicate field names come about
because my table contains two FK's to the same table and the join
query returns data from both FK's.

Many thanks.

David