I am trying to write a report that includes information from the vendor certificate database. The report must also include the YTD vendor activity. The database that includes the YTD vendor activity isn't part of the primary database for the vendors.…