一个关于统计的sql问题

[gpo2002]

Table1 A,B,C
Table2 A,B

统计的条件之一是Table1中A字段的值必须是Table2中A里面存在的。用下面的sql抽
不出
Select Count(Table1.B) as Cnt
from Table1,Table2
Where Table1.A in Table2.A AND ...

请问该如何写这个条件？

[jiezhi]

Select Count(Table1.B) as Cnt
from Table1,Table2
Where Table1.A=Table2.A AND ...

[ss20021008]

.....from table1 where A in (select table2.A from table2 where .....)

[NO1JAVA]

你去除重复值试一试

Select Count(DISTINCT Table1.B) as Cnt
from Table1,Table2
Where Table1.A in Table2.A AND ...

[KingSunSha]

为了避免table1、table2 join的时候出现重复统计，可以使用如下的语法
Select Count(Table1.B) as Cnt
from Table1 x
Where exists (select 1 from table2 where a=x.a);

[Fred_Mark]

up

[gpo2002]

上面两个我开始都试过了，没用

[tang2003]

这个table2的a算是唯一了吧?

Select Count(Table1.B) as Cnt
from Table1,(select a from table2 group by a) Table2
Where Table1.A in Table2.A AND ...

[scapple]

up

[csffox]

关注！！！

[gpo2002]

问题解决了，原来是字段里面的空格引起的问题
ltrim + rtrim 就ok了