是我描述不清楚,这就是个多表查询,id是主键 weight是体重,是我临时想的字段 Select A.* ,B.* from A,B where A.id=B.id and a.sex='男' and weight in(100,150)and age='25' order by weight; 这么写对吗
验证通过支离bz的运行通过... 我是这样写滴 Select A.* ,B.* from A,B where A.id=B.id and b.sex='男' and b.weight >=100 and b.weight <=150 and a.age='25' order by b.weight; 也ok