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 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.field
abc.field
abc.field
from schema.xyz
join schema.abc on
abc.primarykey xyzforeignkey;
Which of the following types of joins should he specify in the query above where the blank blank is
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
