List the vendor_names and address(city, state,zipcode), invoice_total for all the vendors who have active invoices along with those that do not have active_invoices (limit rows = 20). [Hint: Use Onter...

Extracted text: List the vendor_names and address(city, state,zipcode), invoice_total for all the vendors who have active invoices along with those that do not have active_invoices (limit rows = 20). [Hint: Use Onter Join] [vendors, active invoices tables in ex tables.sgl] %3D FROM VENDORS V LEFT OUTER JOIN ACTIVE_INVOICES AI ON V.VENDOR_ID = AI.VENDOR_ID;