Build combined_agreement table from agreement and deal tables

Introduction : Vistex is contract and pricing model The Agreements table is designed to manage and track various agreements in the life sciences domain, providing a structured way to store important details about collaborative efforts and compliance. This table can be critical for ensuring adherence to legal and regulatory requirements while facilitating research and development activities.

 

Requirement:

 

Build or replace the combined_agreement table. This table has to store agreement and deal details along with the customer information .The driving table for the combined_agreement table is agreement and deal.

 

In ‘agreement’ table agree_no is the primary key and in ‘deal’ table deal is the primary key .Join the agreement with ‘customer’ table using source customer id to get the customer information .

 

Join the deal and customer table using source customer id to get the customer information .

 

Develop SQL query to build combined_agreement tables combining agreement & customer and deal & customer .

 

Unity Catalog Information: agreement,deal,customer, combined_agreement