是否这样 select (select count(*) from tablea) from tablea a ,tableb b where a.columna=b.columna 我只要一张表的记录数 因为select count(*) from tablea a ,tableb b where a.columna=b.columna语法要抱错
select count(*) from tablea a ,tableb b where a.columna=b.columna 这样应该能求出总数。select count(*) from tablea a inner join tableb b on a.columna=b.columna或left join.
select count(*) from tablea where columna in (select columna from tableb)
我想统计有几条记录 from tablea a ,tableb b where a.columna=b.columna and where a.colomnc>=0
我想统计有几条记录 select * from tablea a ,tableb b where a.columna=b.columna and where a.colomnc>=0
select Count(a.*) from tablea a ,tableb b where a.columna=b.columna and where a.colomnc>=0
select count(*) as 总记录数 from tablea a full join tableb b on a.columna=b.colomnc
select (select count(*) from tablea)+(select count(*) from tableb)
这样应该能求出总数。select count(*) from tablea a inner join tableb b on a.columna=b.columna或left join.
from tablea a ,tableb b where a.columna=b.columna and where a.colomnc>=0
select * from tablea a ,tableb b where a.columna=b.columna and where a.colomnc>=0