Try this
Also understand that this is just a sample query..You can let me know if there is any issue..and also you can develop from this here on..
Select Partner_ID from Partner_Master pm INNER JOIN Register_Master rm on pm.Reg_ID=rm.Reg_Id
Where rm.Height between pm.HeightFrom and pm.HeightTo