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