Information Systems Access Assignment 12

PARAMETERS __INVNO Value; SELECT DISTINCTROW * FROM [SELECT [InvoiceLine].[PRODNO], [InvoiceLine].[QtySold], [Inventory].[ProdDesc], [Inventory].[UnitPrice], [InvoiceLine].[INVNO] FROM Inventory INNER JOIN InvoiceLine ON [Inventory].[PRODNO] =[InvoiceLine].[PRODNO]]. AS InvoiceMainForm WHERE ([__INVNO] = INVNO);

SELECT Invoice.INVNO, Customer.CustOrgName, Customer.CustCity, Employee.EmpLastName, Employee.CommRate, Invoice.InvDate, Invoice.EmpCode, Invoice.CustCode FROM Employee INNER JOIN (Customer INNER JOIN Invoice ON Customer.[CUSTCODE] = Invoice.[CustCode]) ON Employee.[EMPCODE] = Invoice.[EmpCode];

SELECT Invoice.INVNO FROM Customer INNER JOIN Invoice ON Customer.CUSTCODE = Invoice.CustCode WHERE (((Customer.CUSTCODE)="142"));

SELECT [CustomerSalesQuery].[INVNO], [Customer].[CustOrgName], [Invoice].[InvDate], [Inventory].[PRODNO], [Inventory].[ProdDesc], [Inventory].[UnitPrice] FROM (CustomerSalesQuery INNER JOIN (Customer INNER JOIN Invoice ON [Customer].[CUSTCODE] =[Invoice].[CustCode]) ON [CustomerSalesQuery].[INVNO] =[Invoice].[INVNO]) INNER JOIN (Inventory INNER JOIN InvoiceLine ON [Inventory].[PRODNO] =[InvoiceLine].[PRODNO]) ON [Invoice].[INVNO] =[InvoiceLine].[INVNO];

SELECT [InvoiceLine].[PRODNO], [InvoiceLine].[QtySold], [Inventory].[ProdDesc], [Inventory].[UnitPrice], [InvoiceLine].[INVNO] FROM Inventory INNER JOIN InvoiceLine ON [Inventory].[PRODNO] =[InvoiceLine].[PRODNO];