请教年龄分段的 sql语句

[仙侣步惊云]

dmtb:
xh nllow nlhigh nlfd
1 0 25 T25岁以下
2 26 30 T26—30岁
3 31 35 T31—35岁
...............
9 60 100 T60及岁以上
tbbase
xm nl gzdw
张三 33 单位1
李四 42 单位2
.......
王五 60 单位1

查询：
nlfd zs
T25岁以下 0
T26—30岁 0
T31—35岁 1
.....
T60及岁以上 1

[哥眼神纯洁不]

select nlfd,count(1) as zs from
dmtb,tbbase where nl between nllow and nlhigh
group by nlfd

[仙侣步惊云]

谢谢，结果正确，但没有按xh排序。

[仙侣步惊云]

这样子也可以： SELECT count(*),nlfd FROM vbnl left join dmnl on (nl between nllow and nlhigh) group by nlfd

[daiyueqiang2045]

select nlfd,count(1) as zs from
dmtb,tbbase where nl between nllow and nlhigh
group by nlfd
order by nlfd