>>I believe that you're using the ODBC calling syntax. The ANSI 92 version uses the OUTER JOIN keyword:
>
>Thanks Mike. If I can just figure out how that got there! :)

Did you use the VFP view designer? It uses that syntax when creating remote views with the sql server driver.

BOb