[squeak-dev] ODBC, JOIN table with same column names.

Eric Hochmeister erichochmeister at gmail.com
Thu Jul 17 20:32:06 UTC 2008


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



More information about the Squeak-dev mailing list