SQL Which type of join question? Select one of the following! ARPB_TRANSACTIONS

Question

SQL Which type of join question? Select one of the following!

ARPB_TRANSACTIONS is a table which stores one row for every charge, payment, and adjustment in your professional billing system. PAT_ENC is a table which stores one row for every patient encounter, including office visits You are joining from ARPB_TRANSACTIONS to PAT_ENC to find professional charges generated last month grouped by the clinic where the visit took place. If a charge is not associated with a visit, it should show up in the results grouped as "unknown department." Which join type would be appropriate for this request? TONE OF THE FOLLOWING (1 PT) A. You must use an INNER JOIN or a LEFT OUTER JOIN. Either would return the same results. B. You must use an INNER JOIN. C. You must use a LEFT OUTER JOIN. D. You must use a CROSS JOIN.

Explanation / Answer

You Must use LEFT OUTER JOIN. In the question it was mentioned that you should show up unknown department if no charge is associated. So we have to displa all the rows in the left table with the matching rows in right table. So for this purpose we need to use LEFT OUTER JOIN.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.