Using the IN keyword and a subquery, write a SQL query that returns all columns from a table called “Employee” where the value in a column called “EmployeeID” is found in a column called “EmployeeID” in a table called “Training”:
SELECT * FROM Employee WHERE EmployeeID IN (SELECT EmployeeID FROM Training)
Click the play button to watch the video lesson.
Watch the lesson as many times as needed.
Code along with the instructor using the integrated code editor in the center of your screen.
You can use the Run button beneath the code editor to test your code.
Output from the code that you have written will appear in the panel on the right side of your screen.
If you get stuck or need assistance, you can click the button below to connect with a tutor.