"Must look eye"...
ON WIP_DTL_HIST.DATE_WRK =DAILY_SCRAP.SFT_DATE
AND WIP_DTL_HIST.PAYROLL_SFT_WRK=DAILY_SCRAP.SFT_NUM
AND WIP_DTL_HIST.PART_NUM=DAILY_[highlight]SCARP[/highlight].PART_NUM
AND WIP_DTL_HIST.WKC=DAILY_SCRAP.WC_NUM
--Jeff Moden
Change is inevitable... Change for the better is not.