The following SQL statement selects all the orders from the customer with CustomerID=4 (Around the Horn). We use the "Customers" and "Orders" tables, and give them the table aliases of "c" and "o" respectively (Here we use aliases to make the SQL shorter):
What does this example mean: How is it giving only 2 order id's from order table when there are many rows with employee id=4 in the orders table
Example
SELECTo.OrderID, o.OrderDate, c.CustomerName FROMCustomersASc, OrdersASo WHEREc.CustomerName="Around the Horn"ANDc.CustomerID=o.CustomerID;
Alias for Tables Example
in SQL
Posted
The following SQL statement selects all the orders from the customer with CustomerID=4 (Around the Horn). We use the "Customers" and "Orders" tables, and give them the table aliases of "c" and "o" respectively (Here we use aliases to make the SQL shorter):
What does this example mean: How is it giving only 2 order id's from order table when there are many rows with employee id=4 in the orders table
Example
FROM Customers AS c, Orders AS o
WHERE c.CustomerName="Around the Horn" AND c.CustomerID=o.CustomerID;