The two queries below have a small difference in the last line. Describe the impact of this difference to the results. I
Posted: Fri Jul 08, 2022 6:44 am
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
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