- The Two Queries Below Have A Small Difference In The Last Line Describe The Impact Of This Difference To The Results I 1 (72.98 KiB) Viewed 41 times
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
The two queries below have a small difference in the last line. Describe the impact of this difference to the results. I
The two queries below have a small difference in the last line. Describe the impact of this difference to the results. Is it possible for these two queries to return the same results? If so, in what circumstances? Is it possible for these two queries to return different results? If so, in what circumstances and how would the results be different? SELECT * FROM Person p LEFT JOIN Employee e e.SIN ON p.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 immmmmmmmm