Forgot to say that is an ODBC problem because the same select running
natively on Access works ok.

I will record this problem as bug to be solved on the wiki ODBC page.

Cheers.
Germán.


2008/7/17 Germán Arduino <garduino at gmail.com>:
> 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
>>
>>
>



-- 
Germán S. Arduino
http://www.arsol.biz
http://www.arsol.net