Re: [Q] Problems with Online and SQL-92 joins

On Fri, 27 Mar 1998 13:32:19 +0100, Benjamin Petersen <benjamin@yellow-planner.com> wrote: >What is wrong with this SQL (generated by MSAccess) ? > SELECT * FROM stickerinfo RIGHT JOIN stickers ON>stickerinfo.stickerid = stickers.keyid; > >I can't run it on Online. It gives a syntax error at 'JOIN'.... Yes, because it's not supported by Informix (yet?) as Dave said. If you run it from MS Access or otherwise through ODBC it will work. It will then be automatically translated to the Informix syntax by your ODBC driver. >I know that i can do it like this : > SELECT * FROM stickers, OUTER(stickerinfo) WHERE stickers.keyid =>stickerinfo.stickerid > >but this will only run on informix databases and is not using the SQL-92 >standard. Which is unfortunate but a result of Informix supporting outer joins long before the ANSI standard had them. An ODBC driver solves this however and give you at least the performance of any native driver in most cases. Sometimes even better performance. >Benjamin Petersen, >benjamin@yellow-planner.com > Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: Primary with ODBC info: http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html