[squeak-dev] ODBC, JOIN table with same column names.
Todd Blanchard
tblanchard at mac.com
Fri Jul 18 20:30:16 UTC 2008
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
>
More information about the Squeak-dev
mailing list
|