Re: euEDB / euSQL primary key problem

new topic     » goto parent     » topic index » view thread      » older message » newer message 

c.k.lester wrote:
> 
> duke normandin wrote:
> > 
> > I'll have to take a look at the wxEuphoria code. BTW, I'm almost certain
> > that
> > there is a problem with the way eusql "parses" a SELECT/FROM/WHERE query
> > when
> >  more than one table is involved. For example, the following bombs:
> 
> You probably need a JOIN command in there.
> 
> SELECT NAMES.LASTNAME, ADDRESSES.EMAIL_ADDRESS
> FROM NAMES
> INNER JOIN ADDRESSES
> ON NAMES.ID = ADDRESSES.ID
> WHERE NAMES.ID=ADDRESSES.ID <-- OOPS!!!!

Should be:

WHERE ADDRESSES.SKYPE_ID='perlster'

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu