The following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;
A) equi-join.
B) subquery.
C) Full Outer JOIN.
D) Right Outer JOIN.

In SQL, we can always combine two or more tables based on a common value shared by the tables. One way to join the tables is the equi join. This is a type of join that can combine tables based on the common values shared by some specified columns in the target tables.

The way to write the equi-join query is as follows:

SELECT *

From Table1, Table2

WHERE TABLE1.ColumnA = TABLE.ColumnB

Answer Link

The following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID; A) equi-join. B) subquery. C) Full Outer JOIN. D) Right Outer JOIN.

Respuesta :

Otras preguntas

The following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;
A) equi-join.
B) subquery.
C) Full Outer JOIN.
D) Right Outer JOIN.