>hi all,
>i try to run this code below , i get error message mycur,mycur2 not found
>
>if i change the cursor to table it works
>
>

>SELECT c as  name1,d as title1,e as dept,h as office  FROM ad INTO cursor MYcur
>
>
>thisform.text1.Value=""
>thisform.text1.Value=GETFILE('xls')
>IMPORT FROM (thisform.text1.value)  TYPE XL8 
>SELECT b as  name1,c as job  FROM emp_report INTO cursor MYcur2
>
>
>SELECT  TAlias1.name1,TAlias1.title1,TAlias1.dept,TAlias1.office,TAlias2.job FROM MYcur TAlias1, MYcur2 TAlias2 ;
>**i try as (MYcur) TAlias1, (MYcur2) TAlias2 ;&&not work
>        WHERE  ALLTRIM(TAlias1.name1) = ALLTRIM(TAlias2.name1);     
>                        ORDER BY dept,job; 
>                           INTO cursor TAliascursor1
>

>
>
>thanks

Try to use NOFILTER in your both two select statements, e.g.

SELECT c as name1,d as title1,e as dept,h as office FROM ad INTO cursor MYcur NOFILTER

See http://berezniker.com/content/pages/visual-foxpro/queries-and-filtered-cursors for why it may be important.