Robert,

> So to be more specific: Is
> Tenants."ID" and Members."ID" a "name clash"? It certainly isn't
> in a regular statement.

it is, both in a view and in a "regular statement", as long as we talk
about the FROM clause and not the WHERE clause.
HTH
--
____
_/\/ando