Datasets
Query(s)
SELECT Employee.[First Name], Employee.[Last Name], Orders.[Order Date], Product.[Product Class], Orders_Detail.[Unit Price], Orders_Detail.Quantity, Orders.[Order Amount]
FROM ((Xtreme115DB.dbo.Orders Orders INNER JOIN Xtreme115DB.dbo.[Orders Detail] Orders_Detail ON Orders.[Order ID]=Orders_Detail.[Order ID]) INNER JOIN Xtreme115DB.dbo.Product Product ON Orders_Detail.[Product ID]=Product.[Product ID]) INNER JOIN Xtreme115DB.dbo.Employee Employee ON Orders.[Employee ID]=Employee.[Employee ID]
WHERE (Orders.[Order Date] >= '01/01/2003' And Orders.[Order Date] <= '03/31/2003') And Orders.[Order Amount] > 0 And Employee.[Last Name] IN (@Pm_Employee_Last_Name) And Employee.[First Name] IN (@Pm_Employee_First_Name)
ORDER BY Orders.[Order Date]