Re: ANSI SQL COMPATIBILITY

What you have suggested is indeed how we circumvent the current ODBC driver problems: we create views with whatever joins we need. However, as you know, it is not unheard of (actually it's fairly common) that a developer--one hired to write reports, for example--will not have been granted the right to create views on the server. And sometimes it's not even a developer writing these queries/reports, but a lesser mortal, working with a desktop query tool. So, the use-a-view approach is often not a viable alternative.

Tim

Jan Rosinowski wrote:
>
> >for Oracle 8 as well supports only inner joins ("Oracle's ODBC
> >driver 8.0.X only support [sic] inner joins" -- excerpt from an
> >email from Oracle support, dated 11/10/98).
>
> as we're possibly forced to use oracle/odbc: querying views with outer
> joins etc via odbc is not limited, is it?
Received on Mon Nov 16 1998 - 00:00:00 CST