title: Compare the values in two different tables and return if any of value from a row is different in SQL Server
body: <p>I have two tables <code>Product1</code>** and <code>Product2</code>.</p>
  
  <p><strong>Product1</strong>                        </p>
  
  <pre><code>Product_id  Product_rev Product_Name    Product_description Product_owner   Product_Group   Product_TYPE
  111 AAA CAR SPARE PARTS Nissan  Nissan  AUTOMOTIVE
  222 BBB MODEL   DESGIN  NIFT    NIFT    FASHION
  333 CCC REAR    REAR MATERIAL   KLM KLM GROUP   MANUFACTURING
  444 DDD FINACLE 2.0 BANKING PRODUCT IFLEX   ORACLE  SOFTWARE
  555 EEE TYRE    CEAR TYRES  TATA MOTORS TATA    AUTOMOTIVE
  </code></pre>
  
  <p><strong>Product2_Transform</strong>                      </p>
  
  <pre><code>Product_id  Product_rev Product_Name    Product_description Product_owner   Product_Group   Product_TYPE
  111 AAA CAR SPARE PARTS Ford    Ford    Nissan  AUTOMOTIVE LTD
  222 BBB MODEL   DESGIN  NIFTY   NIFT    FASHION
  333 CCC REAR Head Left  REAR MATERIAL   KLM KLM GROUP   MANUFACTURING
  444 DDD FINACLE 2.5 BANKING PRODUCT Oracle IFLEX    ORACLE  SOFTWARE
  555 EEE SEAT TYRE   CEAR TYRES  TATA BANCS  TATA    AUTOMOTIVE
  </code></pre>
  
  <p>I want the difference values in product1 and product2 and place it in Product_post_validation table..</p>
  
  <p><strong>Product_post_validation</strong> Table:-</p>
  
  <pre><code>Product_id  Product_rev validation_column    value_in_transform       value_in_output
  111 AAA Product_description SPARE PARTS SPARE PARTS Ford
  111 AAA Product_owner   Nissan  Ford
  111 AAA Product_TYPE    AUTOMOTIVE  AUTOMOTIVE LTD
  333 CCC Product_Name    REAR    REAR Head Left
  444 DDD Product_Name    FINACLE 2.0 FINACLE 2.5
  444 DDD Product_owner   IFLEX   Oracle IFLEX 
  555 EEE Product_Name    TYRE    SEAT TYRE
  555 EEE Product_owner   TATA MOTORS TATA BANCS
  </code></pre>
  
  <p>please help in writing query...</p>