Oracle has the lowest level of SQL-92 compliance. Oracle does not
support the use of JOIN in SQL - you must use the WHERE syntax.

You will find that Oracle uses a plus sign enclosed in parens "(+)"
next to the deficient table when performing outer joins.


>We currently have an VFP 6-sp3 application using SQL Server 7 that creates remote views and are trying to migrate it to ORACLE 8.
>
>The question is will Oracle allow the following:
>Create SQL View si_Views_And_Tables Remote Connection JCS1_Conn Shared As Select * From si_Datafiles Join si_Programs On si_Datafiles.datafile_Key = si_programs.datafile_Key
>
>This statement works fine if the connection is to SQL.
>I can get it to work if I use WHERE instead of JOIN.
>Should we be using WHERE's instead?
>
>Thanks