[squeak-dev] ODBC, JOIN table with same column names.
marcelo Cortez
jmdc_marcelo at yahoo.com.ar
Fri Jul 18 01:10:20 UTC 2008
German
what odbc and database you are using?
best
mdc
--- El jue 17-jul-08, Germán Arduino <garduino at gmail.com> escribió:
> De: Germán Arduino <garduino at gmail.com>
> Asunto: Re: [squeak-dev] ODBC, JOIN table with same column names.
> Para: "The general-purpose Squeak developers list" <squeak-dev at lists.squeakfoundation.org>
> Fecha: jueves, 17 de julio de 2008, 8:39 pm
> 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
____________________________________________________________________________________
¡Buscá desde tu celular!
Yahoo! oneSEARCH ahora está en Claro
http://ar.mobile.yahoo.com/onesearch
More information about the Squeak-dev
mailing list
|