select * from A inner B on A.id=B.id where sex='男' and (weight bewteen 100 and 150) and age='25' oder by weight