1awsdfas

SELECT CUSTOMER.CUSTOMER_NUMBER, LAST_NAME, FIRST_NAME, STREET,
APT, CITY, STATE, ZIP, HOME_PHONE, MOBILE_PHONE, OTHER_PHONE,
LINE.INVOICE_ID, PRODUCT_ID, QUANTITY, PRODUCT.PRODUCT_ID,
PRODUCT_NAME, PRODUCT_DESC, PRODUCT_PRICE, INVOICE.INVOICE_ID, NOTES,
ORDER_DATE, CUSTOMER_NUMBER
FROM CUSTOMER JOIN INVOICE
ON CUSTOMER.CUSTOMER_ID = INVOICE.CUSOTMER_NUMBER
JOIN LINE
ON INVOICE.INVOICE_ID = LINE.INVOICE_ID
JOIN PRODUCT
ON PRODUCT.PRODUCT_ID = LINE.PRODUCT_ID;