SELECT t_key, wo_id ; FROM invcont WHERE wo_id = 345245 ; INTO CURSOR tContInvs SELECT tContInvs.*, invcont ; FROM tContInvs ; LEFT JOIN invcont ON tContInvs.wo_id = invcont.wo_id ; INTO CURSOR t1I realise the code is a bit non-sensical but it illustrates my problem. Can someone explain to me why I am getting the problem (i.e. cant use the created cursor)