>Hi,
>
>I applied that but it is opening a file dialogue box and asking for the file name.???
>
>Saif

Spelling : locaction replaced by location

Select simain.sino, ;
	simain.invdate, ;
	simain.pcode, ;
	simain.location, ;
	location.City, ;         && added
	sisub.icode, ;
	sisub.qntymaj, ;
	sisub.qntymin, ;
	sisub.ratemaj, ;
	sisub.ratemin ;
	FROM simain, sisub ;
	    left join location on ( location.pcode + location.location= simain.pcode + simain.location) ;  && added
	WHERE simain.sino = sisub.sino AND ;
	simain.pcode # 'CP011' ;
	Into Cursor tmpsi Readwrite ;
	ORDER By simain.sino