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