Jump to content

hk21

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About hk21

  • Rank
    Newbie
  1. 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 SELECT o.OrderID, o.OrderDate, c.CustomerName FROM Customers AS c, Orders AS o WHERE c.CustomerName="Around the Horn" AND c.CustomerID=o.CustomerID; Try it Yourself ยป
×
×
  • Create New...