title: Oracle select with like from another table
body: <p>Please assist me for complete this query </p>
  
  <pre><code>select *
  from table1 a
  join table2_n n 
  on a.PHONE_NO like '%'|| (select substr(mobile_no,2,9) as mobile_no from table2)
  </code></pre>
  
  <p>table 2 records exists in table1. so i need to get them all from this query  </p>