>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 ;&¬ work > WHERE ALLTRIM(TAlias1.name1) = ALLTRIM(TAlias2.name1); > ORDER BY dept,job; > INTO cursor TAliascursor1 >>