SQL NUMBER 20 CAN NOT USE INNER JOIN LEFT JOIN OR RIGHT JOIN 18. Display all the
ID: 3590789 • Letter: S
Question
SQL NUMBER 20
CAN NOT USE INNER JOIN LEFT JOIN OR RIGHT JOIN
18. Display all the columns in Assignment for those that have one or more rows in Hours. Your overall strategy must be a subquery connected by an “N”. 19. Display all the columns in Assignment for those that have one or more rows in Hours. Your overall strategy must be a subquery connected by an "EXISTS 03 20. Display all the columns in Assignment for those that have one or more rows in Hours. Your overall strategy must be a join Your solution can not contain any subqueries. Note that the sequence of the output rows for Query 18, 19, and 20 may be different, but the overall data values returned must be identical.Explanation / Answer
SELECT *
FROM Assignment RIGHT OUTER JOIN Hours
ON Assignment.eid = Hours.eid
WHERE Assignment.eid IS NOT NULL AND Hours.eid IS NOT NULL
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.