Great tip... and yeah it works. Thanks!

On Fri, Jul 18, 2008 at 4:30 PM, Todd Blanchard <tblanchard at mac.com> wrote:
> I bet you can work around it with aliases though.
>
> SELECT c1.ID as c1_ID, c1.FIRST_NAME as c1_FIRST_NAME, d1.FIRST_NAME as
> d1_FIRST_NAME FROM X c1, Y d1 WHERE c1.ID = d1.ID
>
> -Todd Blanchard
>
> On Jul 17, 2008, at 1:32 PM, Eric Hochmeister wrote:
>
>> 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
>>
>
>
>