title: Sql query Inner join with specific data in string
body: <p>Please find my below 2 table's where i want to execute inner join query with the specific condition.</p>
  
  <p>Table Name:- table1</p>
  
  <p><a href="https://i.stack.imgur.com/mUcDR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mUcDR.png" alt="enter image description here"></a></p>
  
  <p>Table Name:- table2</p>
  
  <p><a href="https://i.stack.imgur.com/Zqlpa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Zqlpa.png" alt="enter image description here"></a></p>
  
  <p>In <strong>table2 column Sr</strong> after <strong>#</strong> there are some number's which is similar to <strong>table1 column Sr</strong> number's.I want to do inner join as per that particular number.</p>
  
  <p>Please guide me with which condition I will managed to do inner joint with described situation. </p>