title: How to use "case when" from two tables
body: <p>My database tables, i need to get the "NEW_IC_NO" from these two tables if they found matched.</p>
  
  <h2>TB_A</h2>
  
  <p><img src="https://i.stack.imgur.com/vjIm4.png" alt="enter image description here"></p>
  
  <h2>TB_B</h2>
  
  <p><img src="https://i.stack.imgur.com/tTTpE.png" alt="enter image description here"></p>