Sergey

Was looking at it from the wrong angle, many thx

Ended up with the following code:

sELECT linemarkinghead.icustno, customers.ccompany, sites.name ;
	FROM linemarkinghead ;
	JOIN customers ON linemarkinghead.icustno = customers.icustno  ;
	JOIN sites ON SITES.icustno = CUSTOMERS.icustno;
	 INTO CURSOR TMP