>How do write a Select where you need to join a local (pre-existing) cursor with one or more tables from the Sql Server??
>
>In this example below from my current DBF-based app, lcCsrMtlRecords is a local cursor and I need join it to some lookup values that need to come from my Sql Server database (Jobs and Users).
>
>

>Select Users.email ;
>	From (lcCsrMtlRecords) ;
>		Join Jobs On Jobs.job_num = &lcCsrMtlRecords..mat_code ;
>		Join Users On Jobs.quoted_by = Users.emp_num ;
>	Where qty_recd <> before_qty_recd ;
>	Order By 1 ;
>	Group By 1 ;
>
>

>
>
>.
I have always pulled the remote data down via SQLEXEC() and then joined the resulting local cursors.

I have no idea if it will work but...................

If you get your Sql Server data via a remote view could you then join the view with a local cursor????