Complete the following tasks using your AP Database.
Please submit 1 .doc file of your SQL statements and a screen shot of a result set showing the data you inserted, updated, or deleted.
I want to change the data in the AP database according to the following requirements.
1. I need an additional payment term for Net due 120 days.
2. I need to delete the Vendor Jobtrak because it has never had an invoice.
3. The vendor Coffee Break Service has moved. The new address is 2325 Neil Armstrong Way Lebanon, OH 45036. The new number is (513) 555-5555.
4. The vendor Office Depot has changed default terms and the default account. They now have 120 days to pay and the default account is PC Software.
Please write the select statements for this please!! Need ASAP!
Yes, the field names and table names. You can use a generic one and I will do it in my SQL!
Thanks
Select * from table_name where sysdate-your_date_field=120
Delete from table_name where vendor_name='Jobtrak'
Update table_name set address= '2325 Neil Armstrong Way Lebanon, OH 45036', phone='(513) 555-5555' where vendor_name='Coffee Break Service'
Update table_name set default_term=120, default_account='PC Software' where vendor_name='Office Depot'
Complete the following tasks using your AP Database. Please submit 1 .doc file of your SQL...
Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...