Invoice/Bill from retail Database in Report Format

COL INVOICE# FORMAT 999
COL SALE_DATE FORMAT A20
COL CUSTOMER FORMAT A20
COL CUST_FNAME NOPRINT
COL CUST_LNAME NOPRINT

SET PAGESIZE 23
SET PAUSE OFF
SET ECHO OFF
SET VERIFY OFF
SET FEEDBACK OFF

UNDEFINE Invoice_Number

PROMPT
PROMPT

-- Creating Report C

TTITLE SKIP 2 "REPORT C:" SKIP 2 "LISTING OF CUSTOMERS PURCHASES &&Invoice_Number" SKIP 3


SELECT PRODUCT.PROD#, QTY_SOLD * PRICE “EXT PRICE”, QTY_SOLD*PRICE*.0725*TAXABLE “SALES TAX”
FROM CUSTOMER, EMPLOYEE, PRODUCT, SALE, SALE_PRODUCT
WHERE CUSTOMER.CUST# = SALE.CUST#
AND SALE.INVOICE# = SALE_PRODUCT.INVOICE#
AND PRODUCT.PROD# = SALE_PRODUCT.PROD#
AND EMPLOYEE.EMP# = SALE.EMP#
AND SALE.INVOICE# = &&Invoice_Number
ORDER BY MFR, PROD_DESC;