> I think it is likely that your query could be improved. Am I right in assuming that you want > there in ALL cases where there is an RPL_PO_ITM to also exist at least one RPL_POBILL_ITM > record and that all matching RPL_POBILL_ITM must have COST defined?
No. In all cases for each RPL_PO_ITM.NDC (RPL_PO_ITM is a child of RPL_PO) there must be a matching RPL_POBILL_ITM.NDC (RPL_POBILL_ITM is a child of RPL_POBILL). Also for each RPL_POBILL_ITM.NDC there must be a matching RPL_PO_ITM.NDC. The NULL COST and PRICE is to see if there is nothing on the other side of the left join. In short, all children of both related parents (there is a joke there somewhere) must match exactly on NDC. Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.
