How to write join query for this

Question

i want query that  
i have two table    from 1st table i want only sno colmn   and 2nd table i want all colmn
how to write join query for this