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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only