Joining Tables in SQL

SELECT customers.CustomerName, customers.ContactName, orders.CustomerID, orders.orderdate

FROM Customers, Orders

WHERE Customers.CustomerID=Orders.CustomerID

An example for Joining two tables. Specifying the tables in the FROM clause. At specifying level: we have used fully qualified names. As you can see above.

Also, we have used fully qualified names on selecting Column names. 

Just like customers.CustomerName or customers.ContactName.