>Hi Naomi,
>
>I got it. Here is what I have. Thanks for your help.
>
>Sam
>
>

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

You're welcome. Keep in mind that all unmatching (e.g. we have PartNum in crsData, but not in crsMPM) crsMPM fields will show NULLs, so you may want to convert them either in SQL or in the report itself using NVL function.

Or you may use SET NULLDISPLAY command.