Re: [INTERFACES] Tables names from query

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 ?