home *** CD-ROM | disk | FTP | other *** search
/ One Click 21 / ONCK021.iso / desenvolvimento / dbtk / dbtkxml.exe / DATA.Z / EmployeeSalesSS.sql < prev    next >
Encoding:
Text File  |  2003-11-29  |  447 b   |  7 lines
  1. SELECT     Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, 
  2.                       [Order Subtotals].Subtotal AS SaleAmount
  3. FROM         Employees INNER JOIN
  4.                       Orders INNER JOIN
  5.                       [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID ON Employees.EmployeeID = Orders.EmployeeID
  6. WHERE     (Orders.ShippedDate BETWEEN '9/1/1996' AND '9/30/1996')
  7.