>i have set filter to shift="A" for my employee table..
>
>i want to set filter to shift="A" for my dtr table..
>
>problem is dtr table doesn't have the shift field.. it only have the empno filed which is also in employee table..
>
>i do this by using the SELECT - SQL..
>
>USE EMPLOYEE
>SET FILTER TO SHIFT="A"
>
>SELECT * FROM dtr ;
> WHERE empno IN (SELECT empno FROM employee WHERE shift="A") ;
> INTO CURSORY mySelect
>
>
>but how do i do this without using SELECT - SQL?

set filter to SHIFT="A"
copy to mySelect
select 0
use mySelect

This, however, creates a table. You don't really need a filter for this; you can "copy ... for {your filter expression here}".

If you don't want to have a table on disk, you can create a cursor with the fields you need and append:

create cursor mySelect ({fields here})
append from dtr for SHIFT="A"