这个SQL语句怎么写？

[wanglh]

数据库中有两个表，TA，TB，其结构如下：
TA TB
------------- -----------
A B A B


字段类型A字符串，B整形
要求是：
返回TA中的A，及D（一数值计算结果）
D的值计算方法是在TA.A=TB.A条件下，TB.B<TA.B的个数
不能用分组，返回的行数等于TA中所有的行数

[pengdali]

select * from ta,tb where ta.a=tb.a and tb.b<ta.b


select count(*) 个数 from ta,tb where ta.a=tb.a and tb.b<ta.b

[pengdali]

你是要这个吧：
select *,(select count(*) from tb where a=ta.a and b<ta.b) 个数 from ta

[CrazyFor]

select *,(select count(*) from tb where tb.a=ta.a and tb.b<ta.b) 个数 from ta

[dafu71]

select A,(select sum(1) from tb where a=ta.a and b<ta.b) as D from ta

[mistral]

select A,(select count(*) from tb where a=ta.a and b<ta.b) as D from ta

[hjb111]

select *,(select count(*) from tb where tb.a=ta.a and tb.b<ta.b) as 个数 from ta

[rs_net]

select A,(select count(B) from TB where A=TA.A and B<TA.B) as D from TA