Using an inner join, write a SQL query that returns all columns from tables called “Phone” and “Employee”, where the phone table has a column called “EmployeeID” that is a foreign key to a column called “EmployeeID” in the employee table (do not use table aliases, e.g., “Phone AS p”):
SELECT * FROM Phone INNER JOIN Employee ON Phone.EmployeeID = Employee.EmployeeID
SELECT * FROM Phone INNER JOIN Employee ON Employee.EmployeeID = Phone.EmployeeID
SELECT * FROM Employee INNER JOIN Phone ON Phone.EmployeeID = Employee.EmployeeID
SELECT * FROM Employee INNER JOIN Phone ON Employee.EmployeeID = Phone.EmployeeID
Any of the above are correct
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.