Hi:

You are right. I tried and have the same behaviour, never detected
before. (I tried with an Access DB builded fastly, but the problem is
the same you comment).

Never heard about this behaviour, but if time permit, I will investigate a bit.

Cheers.
Germán.


2008/7/17 Eric Hochmeister <erichochmeister at gmail.com>:
> Hi,
>
> I'm using the ODBC driver for squeak and I was running into an issue
> with JOIN tables where the 2 tables I'm joining have identical column
> names.
> ie. I have a table X and table Y.
> both tables have columns ID, FIRST_NAME
>
> So when I do the query,
>
> SELECT c1.ID, c1.FIRST_NAME, d1.FIRST_NAME FROM X c1, Y d1 WHERE c1.ID = d1.ID
>
> I get back rows which only have ID and FIRST_NAME (2 columns), rather than 3.
>
> I'm just curious if this is a known bug, or if I'm missing something,
> ie. not doing this correctly.  Has anyone else run in to this issue,
> or do you solve it differently?
>
> Thanks,
>
> Eric
>
>