OpenEuphoria

Re: euEDB / euSQL primary key problem

• Posted by duke normandin <dnormandin at bsdrocksperlrolls.com> Feb 19, 2007
• 508 views

Matt Lewis wrote:
> 
> duke normandin wrote:
> > 
> > hey....
> > 
> > This query passed as well AND worked.......
> > 
> > SELECT     STUDENTS.NAME
> > FROM       STUDENTS 
> > INNER JOIN PARTICIPANTS 
> > ON         STUDENTS.ID=PARTICIPANTS.PK.ID 
> > WHERE      PARTICIPANTS.PK.ACTIVITY='Swimming'
> > 
> > Go figure!
> > 
> > I must have set it up correctly ;) I should crank out a mini-HOWTO 
> > eventually on database normalizing and setting up euSQL via "edb" and 
> > manually as well I suppose. Thanks!
> 
> I'm not sure why the previous query didn't work, though I can tell you that
> 
> JOINs work better than an implicit join using a WHERE clause.  JOINs are 
> better optimized, especially if there are indices created on the joined
> fields.
> 
> Matt

Makes sense! Thanks for getting back to me. BTW, how hard would it be to add
username/password feature to euSQL in order to "connect" to a database?

I realize that the "authentication" phase could be done quite seperately, but
I'm interested in the "builtin" server/client approach. L8r...
--
duke
SW of Calgary - near the Rockies
http://www.rootshell.be/~perlster/euphoria/