With Query Example

 with sam as 
(
 select * from TblSample
  )
  select * from  sam as s join TblSample1 as Sn on sn.id=s.id

OutPut
ID	Name	Age	Sex	ID	Name	Age	Sex
1	vino	23	Male	1	vino	23	Male
2	karthick	25	Male	2	karthick	25	Male
3	Rajesh	24	Male	3	Rajesh	24	Male