1) Write a SELECT statement that returns all columns from the Vendors table inner-joined with all columns from the Invoices table. Select only those vendors in the state of California "CA". 1) Write a SELECT statement that returns all columns from the Vendors table inner-joined with all columns from the Invoices table. Select only those vendors in the state of California "CA