Question: Shashank is writing a SQL query with tables ABC and x Y Z ( from schema named 'schema' ) . He wants to return only

Shashank is writing a SQL query with tables ABC and xYZ(from schema named 'schema'). He wants to return only the records from ABC where there is not a corresponding record in XYZ (as displayed in the Venn diagram below:
His query so far is the following:
select
abc.field1,
abc.field2,
abc.field3
from schema.xyz
join schema.abc on
abc.primarykey = xyz.foreignkey;
Which of the following types of joins should he specify in the query above where the blank (blank) is?
Shashank is writing a SQL query with tables ABC

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!