3 The table IB_ RECEIVER stores who received each In Basket message. The column IB RECEIVER.RECIPIENT stores the ID of the recipient. This is a patient ID if the message was sent to a patient, or a staff ID if the message was sent to staff. When a message is sent to a patient, IB RECEIVER.REGISTRY ID 8. When a message is sert to staff, IBRECEVER.REGISTRY-ID-1. Patient IDs are stored in PATIENT PAT ID Which of the following will return all In Basket messages, join In Basket messages to patient recipients, and ensure no messages sent to staff are joined to patients? If a join criterion is not needed, do not use it. T ONE OF THE FOLLOWING (1 PT) A. FROM IB-RECEIVER INNER JOIN PATIENT ON IB-RECEIVER.RECIPIENT = PATIENT,PAT_1D B. FROM IB-RECEIVER LEFT OUTER JOIN PATIENT ON IB-RECEIVER.RECIPENT-PATIENT,PAT-O C. FROM IB RECEIVER INNERON PATIENT ON B-RECEIVER.RECIPIENT. PATIENT.PAT ID AND 18_RECEIVER.REGISTRY ID8 D. FROM IB. RECEIVER LEFT OUTER JOIN PATIENT ON IB RECEIVER.RECIPIENT PATIENT,PAT ID AND IB RECEIVER.REGISTRY ID 8