Display the required columns from d_product and d_product_hist

 

 

Requirement: Develop Databricks SQL query to join d_product and d_product_hist table on item_nbr column and display the hashed value of all the columns in d_product table along with valid from and valid till in d_product_hist table.

 

 

 

Expected Output: SQL query