>Is it possible to join data from a local cursor with a table on a SQL server using the sqlexec() function. If so what would the syntax be?
No. Bear in mind, the code passed to the backend via SQLEXEC runs on the backend, which knows nothing about your local VFP environment.
You can, however, combine a remote view a local cursor in a local SELECT - SQL.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up