Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FROM a in db.Orders
- where a.Total > 100
- SELECT new {a.Item.Desc, a.Customer.Name};
- select i.DESC, c.NAME
- from ORDERS o
- inner join ITEMS on o.ItemID = i.ItemID
- inner join CUSTOMERS c on o.CustomerID = c.CUSTOMERID
- where o.TOTAL > 100
Add Comment
Please, Sign In to add comment