title: How to join two table based on condition?
body: <p>There are three table A,B,C</p>
  
  <p>A table columns are Name,ID,Address</p>
  
  <p>B table columns are ID,Address,School</p>
  
  <p>C table columns are School,address,cafe</p>
  
  <p>If Name='A'
  Then Table A and Table B will join based on A.ID =B.ID</p>
  
  <p>IF Name='B'</p>
  
  <p>Then Table A and Table B will join based on A.ID =B.ID and A.Address=B.Address</p>
  
  <p>And this result with join with Table C</p>