You need to re-design your tables to split the name into the relevant parts, so have a field for first name, surname, title etc. Secondly joining on text fields like name is very prone to error, so instead of storing the name in Table2 you should store the ID of table 1
SNO| SNO_ID |
10 | 1 |
20 | 2 |
30 | 3 |
That will let you do a query to get you the data you need
SELECT t2.SNO, t1.Name, T1.ID from Table1 t1 join Table1 t2 on t2.SNO_ID = t1.SNO