Hi evreryone! I am working on a project in which I have to perform a join of three tables. Not all of the tables will contribute data in the results. Here is the code that I have so far…
SELECT Customers.CompanyName,Customers.ContactName,customers.phone
FROM orders
JOIN customers
ON Orders.orderid=Customers.CustomerID
JOIN Employees
ON Customers.CustomerID=Employees.EmployeeID
Am I on the right track with this syntax and do I need to include a ‘WHERE’ statement, because the column names show up, but nothing else.
