Compare CATA, and CATB Versions

diffVersionCatalogs.sql

-- Compare VERSION column, CATA vs CATB    
SELECT
  COALESCE(CATA.PRICE_ID, CATB.PRICE_ID) AS PRICE_ID,
    CASE 
      WHEN CATA.VERSION = CATB.VERSION THEN 'Equal'
      WHEN CATA.VERSION <> CATB.VERSION THEN 'Changed'
    END AS STATUS,
    CATA.VERSION AS CATA_VERSION,
    CATB.VERSION AS CATB_VERSION
  FROM
    WLM_PROD_CATA.DCS_PRICE CATA FULL JOIN WLM_PROD_CATB.DCS_PRICE CATB
      ON CATA.PRICE_ID = CATB.PRICE_ID;