SELECT crsData.*, crsMPM.* ; FROM crsData LEFT JOIN crsMPM ; ON crsData.PartNum = crsMPM.PRTNUM_49 ; INTO CURSOR crsReport