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
The two queries below have a small difference in the last line. Describe the impact of this difference to the results. I
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am