CUSTOMER CUST NUMBER CUST LNAME CUST FNAME CUST INITIAL CUST AREACODE CUST PHONE
ID: 3836218 • Letter: C
Question
CUSTOMER CUST NUMBER CUST LNAME CUST FNAME CUST INITIAL CUST AREACODE CUST PHONE CUST BALANCE 615 Orlando 222-1672 10014 Myron 10015 O'Brian 713 442-3381 INVOICE NV NUMBER CUST NUMBER NV DATE INV SUBTOTAL INV TAX NV TOTAL INV PAY TYPE NV PAY AMOUNT NV BALANCE 1001 10014 2016-11-17 00:00:00.000 108.99 8.05 117.04 117.04 CC 193.99 14.32 208.31 208.31 0 10015 1003 2016-01-18 00:00:00.000 LINE NV NUMBER LINE NUMBER PROD CODE LINE UNITS LINE PRICE LINE AMOUNT 4243213 1001 1001 200247 69.99 69.99 1003 4243213 1003 0637032 1003 1200247 69.99 69.99 10. Delete the returned items from LINEtable 5Explanation / Answer
please find the below query to delete the line items with conditions in case the customer number is added to Line table
SQL> DELETE FROM LINE
WHERE CUST_NUMBER = 10014;