title: Correlate 2 columns in SQL
body: <pre><code>SELECT ica.CORP_ID, ica.CORP_IDB, ica.ITEM_ID, ica.ITEM_IDB, 
  ica.EXP_ACCT_NO, ica.SUB_ACCT_NO, ica.PAT_CHRG_NO, ica.PAT_CHRG_PRICE, 
  ica.TAX_JUR_ID, ica.TAX_JUR_IDB, ITEM_PROFILE.COMDTY_NAME
  FROM ITEM_CORP_ACCT ica
  ,ITEM_PROFILE
  WHERE (ica.CORP_ID = 1000) 
  AND (ica.CORP_IDB = 4051) 
  AND (ica.ITEM_ID = 1000) 
  AND (ica.ITEM_IDB = 4051)
  AND ica.EXP_ACCT_NO = ITEM_PROFILE.EXP_ACCT_NO
  </code></pre>
  
  <p>I'm trying basically say since the exp account code is '801500' then the Name should return "Miscellaneous Medic...".</p>
  
  <p><a href="https://i.stack.imgur.com/uhe33.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uhe33.jpg" alt="enter image description here"></a></p>