Roi,

The select you posted had a where clause that limited the results to ab_id 57. If you want them all then dump teh where clause;

SELECT catlink.ab_id, catagory.catagory ;
	FROM catagory ;
	LEFT JOIN  catlink ;
	ON catlink.catagory = catagory.catagory ;
	where catlink.ab_id = 57 ; && <strong>Remove this part of the select</strong>
	INTO CURSOR temp