RE: Newbie: Questions about SAPDB

"Becker, Holger" <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]> 
Reggie White wrote:

> I'm using the Internal SQL Mode, and need to know does this 
> database support
> the TRUE SQL-92 Outer Join specifications, i.e. LEFT OUTER, 
> RIGHT OUTER,
> etc.

SAP DB supports a subset of the SQL-92 Join specification.
LEFT, RIGHT and FULL OUTER Joins are supported.

For the complete syntax have a look into this part of the refernce manual
http://www.sapdb.org/7.4/htmhelp/ea/eba4f43e9211d3a98200a0c9449261/frameset.htm

But be aware that SAP DB had some bugs within outer joins in the past.
Please check the mailing list archive for detailed information.

Best regards,
Holger
SAP Labs Berlin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.