SELECT ARInv.InvoiceDate, Customer.CustomerName, 
       ARInv.InvoiceNo, ARInv.Description, 
       ARInvDet.Quantity, Item.ItemDescription, 
       ARInvDet.UnitPrice, Salesman.FirstName, 
       Salesman.LastName, ARInv.SalesmanID, 
       Item.StandardCost, Item.ItemTypeID, 
       Quantity * ABS(UnitPrice) Quantity_ABS_UnitPrice, 
       Quantity * standardcost Quantity_standardcost
FROM "ARInv.DAT" ARInv
      INNER JOIN "ARInvDet.DAT" ARInvDet ON 
     (ARInvDet.ARInvoiceID = ARInv.ARInvoiceID)
      INNER JOIN "Customer.DAT" Customer ON 
     (Customer.CustomerID = ARInv.CustomerID)
      INNER JOIN "Salesman.DAT" Salesman ON 
     (Salesman.SalesmanID = ARInv.SalesmanID)
      INNER JOIN "Item.DAT" Item ON 
     (Item.ItemID = ARInvDet.ItemID)
WHERE 
      ( ARInv.InvoiceDate BETWEEN '4/1/2001' AND '6/1/2001' )
       AND ( Item.ItemTypeID <> 8042 )
ORDER BY ARInv.SalesmanID, ARInv.InvoiceDate