Inner Join

  1. 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”):
    1. SELECT * FROM Phone INNER JOIN Employee ON Phone.EmployeeID = Employee.EmployeeID
    2. SELECT * FROM Phone INNER JOIN Employee ON Employee.EmployeeID = Phone.EmployeeID
    3. SELECT * FROM Employee INNER JOIN Phone ON Phone.EmployeeID = Employee.EmployeeID
    4. SELECT * FROM Employee INNER JOIN Phone ON Employee.EmployeeID = Phone.EmployeeID
      1. Any of the above are correct

Instructions: 

  1. Click the play button to watch the video lesson.
  2. Watch the lesson as many times as needed.
  3. Code along with the instructor using the integrated code editor in the center of your screen.
  4. You can use the Run button beneath the code editor to test your code.
  5. 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. 

For additional questions or technical support, email support@veroskills.com