Michel,

You can pull down all the possibly related SQL data into another VFP cursor, then do the JOIN on the two cursors. Or you can push your cursor into a SQL table and then do the JOIN in SQL and return the results. Or you can put the cursor into a VFP table and then have a SQL SP do the JOIN using OPENROWSET to access the VFP data directly over ODBC. There may even be a few more ways to do it, but the way I'd recommend (without know how much data is involved -- which could alter the option chosen) is the first one. Pull down the SQL data and JOIN the two cursors in VFP. The other options are less reliable or more klunky IMO.

HTH,
Chad

>I have created a cursor. That cursor should be in a SQL where the INNER JOIN with a table from the backend. How can I succeed to execute a SQLExec() where one of those tables is a cursor?