home *** CD-ROM | disk | FTP | other *** search
/ Mastering Internet Develo…oft ActiveX Technologies / Mastering Internet Development with ActiveX (1996)(Microsoft).iso / labs / webfinal / scripts / tdsales.idc < prev   
Encoding:
Text File  |  1996-07-16  |  318 b   |  10 lines
  1. Datasource: WebMainSt
  2. Template: TDSales.htx
  3. SQLStatement:
  4. +SELECT orders.OrderID, orders.OrderDate, Sum([Quantity]* [UnitPrice])/100*100 AS OrderTotal
  5. + FROM Orders, [Order Details]
  6. + WHERE Orders.OrderID = [Order Details].OrderID AND Orders.OrderDate = #%Date%#
  7. + Group By Orders.OrderID, Orders.OrderDate
  8.  
  9.  
  10.