How to write join query for this

I am assuming that you want inner join for you rquery,
see below query for your requirement:

SELECT a.sno,b.* FROM table1 a inner join table2 b on a.pkey =b.fkey