Mace,
Thank you, that work!
Thanks,
Jerry
>Jerry,
>
>Which version of Oracle are you using. Oracle did not add support for the 'OUTER JOIN' syntax until version 9.
>
>Prior to that you have to use the (+) on your join statements. For example, the syntax below will return all the rows in the SO table and Nulls if there is no item.
>
>Mace
>
>TEXT to lc_SQL TEXTMERGE NOSHOW PRETEXT 3
>SELECT *
> FROM myOracle.SO So, myOracle.ITEM Item
> WHERE So.ITEM = Item.ITEM (+)
> AND So.so = ?lc_so
> ORDER BY So.so_line
>ENDTEXT
>lc_SQL = STRTRAN(lc_SQL, CHR(13) + CHR(10), [ ])
>ln_result = SQLEXEC(myconn, lc_sql, 'c_so')
>
>
>
>
>
>>How can I perform a LEFT or RIGHT join on 2 tables in Oracle from VFP? I can get an inner join to work but not a Left or Right.
>>
>>
>>***Works.
>>TEXT to lc_SQL TEXTMERGE NOSHOW PRETEXT 3
>>SELECT *
>> FROM myOracle.SO So, myOracle.ITEM Item
>> WHERE So.ITEM = Item.ITEM
>> AND So.so = ?lc_so
>> ORDER BY So.so_line
>>ENDTEXT
>>lc_SQL = STRTRAN(lc_SQL, CHR(13) + CHR(10), [ ])
>>ln_result = SQLEXEC(myconn, lc_sql, 'c_so')
>>
>>
>>***Does NOT work. Returns a -1.
>>TEXT to lc_SQL TEXTMERGE NOSHOW PRETEXT 3
>>SELECT *
>> FROM myOracle.SO So LEFT JOIN myOracle.ITEM Item
>> ON So.ITEM = Item.ITEM
>> AND So.so = ?lc_so
>> ORDER BY So.so_line
>>ENDTEXT
>>lc_SQL = STRTRAN(lc_SQL, CHR(13) + CHR(10), [ ])
>>ln_result = SQLEXEC(myconn, lc_sql, 'c_so')
>>
>>
>>Thanks,
>>
>>Jerry