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 ;
LEFTJOIN catlink ;
ON catlink.catagory = catagory.catagory ;
where catlink.ab_id = 57 ; && <strong>Remove this part of the select</strong>INTOCURSOR temp