>>When you upsize the Visual FoxPro 5.0 database to SQL SERVER or ORACLE database,
>>does the joins sections in the local view changes correctly to support the SQL SERVER or ORACLE remote view.
>
>Sonny,
>I have used the Upsize Wizard once so far for a fairly small application that was prototyped using VFP 5. For the most part it worked pretty darn well. It converted all of the local views to remote views. And as far as I can remember I didn't have any problems with these views. This was upsized to SQL Server BTW.
>
>HTH,
>George

Thanks, I wasn't sure if the following statement was converted!

SELECT myTable1.*, myTable2.*
FROM myTable1 INNER JOIN myTable2 ON myTable1.key = myTable2.key
WHERE myTable1.name = ?pCName

I know that ODBC does only support LEFT JOIN and NO JOIN options. I just wanted to make sure that the above statement was converted.