Choose all that apply. Thank you in advance! The ORDER_DISP_INFO table and V_RX_

Question

Choose all that apply. Thank you in advance!

The ORDER_DISP_INFO table and V_RX_DISPENSE view both have the same level of granularity. They each dispense by the columns ORDER_MED ID and CONTACT_DATE_REAL. In order to use columns from both tables in your query, you must join the two tables like so: FROM ORDER_DISP INFO INNER JoIN V_RX_DISPENSE ON Which of the following expressions do you need in your join? T ALL THAT APPLY (1 PT) A. ORDERDISP?NFO.ORDERMEDID = ORDERDISPINFO.ORDERMEDID B. ORDER-DISP-INFO·CONTACT DATE-REAL =V_AX-DISPENSE.CONTACT DATE REAL C. ORDER-DISP-?NFO.ORDER-MED-ID = V_AX-DISPENSE.ORDER-MED-ID D. ORDER-DISP-INFO.CONTACT-DATE-REAL >=V_RX-DISPENSE.CONTACT DATE-REAL --------

Explanation / Answer

Option C is the rightanswer. generally joins are performed on the tables based on the common key presented in both th tables which was unique. So in the above tables MED_ID was a common keyfor both the tables.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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