SQL Inner Join Question. Select all that apply! LOG tables You write a query to

Question

SQL Inner Join Question. Select all that apply!

LOG tables You write a query to compare surgical cases and logs, represented by the OR_CASE and OR LOG tables, respectively. If a log has an associated case, the column OR_ LOG.CASE_ID will store the case's ID. If there is no associated case, OR_LOG.CASE_ID will be NULL. You build your query using the following FROM clause: case, OR LOG.CASE ID wiomm OR LOGC FROM OR LOG orl INNER JOIN OR_CASE orc ON orl.CASE_1D = orc.CASE..ID f the following would be T ALL THAT APPLY (1 PT) A. A log with no associated case B. A log associated with a case C. A case with no associated log D. Rows with no case or log

Explanation / Answer

Answer)

The answer to the above is :

It is an inner join hence its B) A log is associated with the case.

Hope this answer helps. Happy to help. :)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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