Question

Which clause creates an equijoin between two tables using one column from each table regardless of the name or data type.

Answer 1

Answer:

An ON clause creates an equijoin between two tables using one column from each table regardless of the name or data type.

Example:

Table name: Orders

OrderID CustomerID OrderDate

10308 1             1996-09-18

10309 2                   1996-09-19

10310 3              1996-09-20

Table name: Customers

CustomerID CustomerName   ContactName       Country

1               Futterkiste        Maria Anders            Germany

2                  Empared                  Ana Trujillo        Mexico

3                  Taquería                 Antonio                Mexico

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate

FROM Orders

INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

OrderID CustomerName OrderDate

10308 Futterkiste           1996-09-18

10309 Empared                   1996-09-19

10310 Taquería                     1996-09-20

Answer 2

Answer:

Join condition becomes essential when data is required  from multiple tables. ON clause creates an equijoin between two tables using one column from each table regardless of the name or data type While on the other hand, USING clause creates an equijoin between different tables of the same name and regardless of their type of data.