SELECT TableA.*, TableB.FieldName ;
  FROM TableA LEFT JOIN TableB ;
    ON TabelA.Pk = TableB.Fk ;
 <strong>GROUP BY TableA.PK</strong> ;
INTO CURSOR MyResult