Hi Larry!

Thanks for help. It looks a bit strange ;)

For connecting to an oracle-database I'll have to use ODBC, SqlStringConnect won't work - is this right or wrong?


>>Hi all!
>>
>>Can someone give me a hint on how different Oracle-SQL is compared to Microsoft SQL?
>>
>>AFAK Oracle doesn't support inner-/left-/right-joins - only full joins. Is this info right?
>>Are there any differences in using Group-By, Union,Create table,...
>>
>>Thanks for help.
>
>Robert,
>Oracle does support both inner and outer joins. The syntax is different. Where VFP and SQL Server use the keyword(s) LEFT|RIGHT OUTER JOIN, Oracle uses the (+) sign to designate an outer join. Ex.

>select a.field1, nvl(b.field2)
>   from table1 a, table2 b
>   where a.field1 = b.field1(+)

>This is a left outer join.
>
>You can't use create table in an Oracle procedure/function/package. You have to use dynamic SQL to handle situations like this (see EXECUTE IMMEDIATE).
>
>HTH.