>I have two cursors crsData and crsMPM. I need to put the MfgName and MfgNum into crsData with specific PartNum from crsMPM. However, some of the PartNum in crsData does not have MfgName and MfgNum. How can I just add these two fields to the specific PartNum and still keep the PartNum without the MfgName and MfgNum in crsData. Please help. Thanks, Sam

select crsMPM.*, nvl(crsData.MfgName, space(30)) as MfgName, ... ;
from crsMPM left join crsData on crsMPM.PK = crsDara.FK