SQL Inner Join Question. Select all that apply! You write a query to return pati

Question

SQL Inner Join Question. Select all that apply!

You write a query to return patients and their primary care providers (PCP). If a patient has a current PCP, the column CUR_PCP_PROV_ID will store that provider's ID. If a patient has no current PCP, it will be NULL You build your query using the following FROM clause: FROM PATIENT pat INNER JOIN CLARITY_SER ser ON pat.cUR_PCP_PROV_IDser.PROV_ID Which of the following cases would be in the results? T ALL THAT APPLY (1 PT) A. A patient with no current PCP B. A patient with a current PCP C. A provider who is the curent pco of mutiple patients D. A provider who is not currently the PCP of any patient

Explanation / Answer

Answer:

B. A patient with a current PCP

C. A provider who is the current PCP of multple patients.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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