SELECT catlink.ab_id, catagory.catagory ; FROM catagory ; LEFT JOIN catlink ; ON catlink.catagory = catagory.catagory ; where catlink.ab_id = 57 ; INTO CURSOR temp