Question: Please assist me for complete this query 

```
select *
from table1 a
join table2_n n 
on a.PHONE_NO like '%'|| (select substr(mobile_no,2,9) as mobile_no from table2)

```

table 2 records exists in table1. so i need to get them all from this query

Answer: 
Why do you need to use like and subquery, any how you have joined 2 tables with phone\_no column, then it'll return all the matching records.
Use rownum=1 or where condition to return only one row from the inner sub query otherwise it would not work for multiple recods in table2.