Philip Shiels wrote:
> SELECT x.y, z.y from x, y where x.key = z.key
>
> The problem with the above is that I get back 2 fields called 'y' and have no
> way of knowing from which tables they've come from.
Do something like this:
SELECT x.y, z.y AS z_y from x, z where x.key = z.key;
> Is there is a way of identifying the originating tables ?