Set A is squares and Set B is red shapes. For each one of the joins above, describe what will be shown. For example: Join 1 will show circles that are also purple.
Set A is squares and Set B is red shapes. For each one of the joins above, describe what will be shown. For example: Join 1 will show circles that are also purple.
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter11: Sql Server Databases
Section: Chapter Questions
Problem 10E
Related questions
Question
Set A is squares and Set B is red shapes.
For each one of the joins above, describe what will be shown. For example: Join 1 will show circles that are also purple.
Transcribed Image Text:SQL JOINS
A
|B
A
B
SELECT <select_list>
1. FROM TableA A
LEFT JOIN TableB B
ON A.Key = B.Key
SELECT <select_list>
2. FROM TableA A
RIGHT JOIN TableB B
ON A.Key = B.Key
A
В
A
В
SELECT <select_list>
A
7. FROM TablcA A
INNER JOIN TableB B
ON A.Key = B.Key
SELECT <select_list>
3 FROM TableA A
LEFT JOIN TableB B
ON A.Key = B.Key
WHERE B.Key IS NULL
SELECT <select_list>
4. FROM TableA A
RIGHT JOIN TableB B
ON A.Key = B.Key
WHERE A.Key IS NULL
A
A
SELECT <sclect_list>
5. FROM TableA A
FULL OUTER JOIN TableB B
ON A.Key = B.Key
SELECT <sclect_list>
FROM TableA A
FULL OUTER JOIN TableB B
6. ON A.Key = B.Key
WHERE A.Key IS NULL
OR B.Key IS NULL
OCL Moffatt, 2008
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning