Joining RcvDTL to NONCONF

I am trying to figure out how to connect RCVDTL records to NONCONF as NONCONF has the DMRnum if there is one associated with the RCVDTL record.

My plan was something like

Select
*
from RCVDTL RD
join NONCONF NC on RD.POnum = NC.POnum and RD.POline = NC.POline and RD.PORelNum = NC.PORelNum

but I am worried about the possibility of having to RCVDTL records associated with a single PO release. How can I get the one-to-one relationship?

Regards,

Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176



[Non-text portions of this message have been removed]