Assume you are using two tables for an SQL query: Therapist and Session. You want to make

Question:

Assume you are using two tables for an SQL query: Therapist and Session. You want to make sure that you display all the names of the therapists even if they are not yet booked into a session. What join do you need to create to ensure that all the therapists are listed?

a. LEFT JOIN Therapist ON Therapist.TherapistID=Session.TherapistID

b. RIGHT JOIN Therapist ON Therapist.TherapistID=Session.TherapistID

c. INNER JOIN Therapist ON Therapist.TherapistID=Session.TherapistID

d. OUTER JOIN Therapist ON Therapist.TherapistID=Session.TherapistIDSession Num 27 28 29 30 31 32 33 34 35 36 37 38 SessionDate 10/10/2021 10/11/2021 10/11/2021 10/12/2021

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: