The two queries below have a small difference in the last line. Describe the impact of this difference to the results. I

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

The two queries below have a small difference in the last line. Describe the impact of this difference to the results. I

Post by answerhappygod »

The two queries below have a small difference in thelast line. Describe the impact of this difference to the results.Is it possible for these two queries to return the same results? Ifso, in what circumstances? Is it possible for these two queries toreturn different results? If so, in what circumstances and howwould the results be different?
SELECT *
FROM Person p
LEFT JOIN Employee e
ON p.SIN = e.SIN
LEFT JOIN Customer c
ON p.SIN = c.SIN
SELECT *
FROM Person p
LEFT JOIN Employee e
ON p.SIN = e.SIN
LEFT JOIN Customer c
ON e.SIN = c.SIN
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply