SQL99 ANSI syntax

#1

Hello to everyone.
I'm quite new to this newgroup and probably this matter has already been
talked about.
I'm trying to use SLQ99 ANSI syntax about joins on an sqlbase 9.0 database
but without any success.
I read on the sqllang.pdf that the standard syntax would be supported on
version 8.5 and later and I saw quite a few examples on the document.
Would anyone submit an example of a working sql command including a join,
please ?
Thanks
Alberto

#2

Albe schrieb:

Quote:

Hello to everyone.
I'm quite new to this newgroup and probably this matter has already been
talked about.
I'm trying to use SLQ99 ANSI syntax about joins on an sqlbase 9.0 database
but without any success.
I read on the sqllang.pdf that the standard syntax would be supported on
version 8.5 and later and I saw quite a few examples on the document.
Would anyone submit an example of a working sql command including a join,
please ?
Thanks
Alberto

Have you set "ansijoinsyntax=1" in sql.ini?
SQLBase Database Administrator's Guide, page 3-11

HTH

-Niels-

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL99 ANSI syntax

comp.databases.gupta comp.databases.gupta

SQL99 ANSI syntax - 07-04-2006 , 03:06 AM

Re: SQL99 ANSI syntax - 07-07-2006 , 05:12 AM