Joining Data Between Two Tables via a JSON Field in SQL Server

Extracting Attribute Names and Values from JSON Data in SQL Server Using OPENJSON Function