Computer Science Home work!

SELECT DISTINCTROW * FROM Merchandise;

PARAMETERS __CategoryID Value; SELECT DISTINCTROW * FROM [Quarterly Sales] AS [Merchandise Sales Entry Form] WHERE ([__CategoryID] = CategoryID);

SELECT [Category Experts].Firstname, [Category Experts].Lastname, [Category Experts].City, [Quarterly Sales].QtrSales, Merchandise.Merchandise FROM Merchandise INNER JOIN ([Category Experts] INNER JOIN [Quarterly Sales] ON [Category Experts].ExpertID=[Quarterly Sales].ExpertID) ON Merchandise.CategoryID=[Quarterly Sales].CategoryID ORDER BY [Category Experts].Firstname, [Category Experts].Lastname, Merchandise.Merchandise;

SELECT DISTINCTROW * FROM [Category Experts];

PARAMETERS __ExpertID Value; SELECT DISTINCTROW * FROM [Quarterly Sales] AS [Category Experts Form] WHERE ([__ExpertID] = ExpertID);