SQL 乘法

[luckyzhangye]

(select count(*) from t_familymember tf where tf.familyid in (select familyid from t_publicrentcontract
where operationtype=3 and familyid in
(select id from t_familybasicinfo where county=305 and id=808)))*
((select count(*)from t_publicrentcontract
where operationtype=3 and familyid in
(select id from t_familybasicinfo where county=305 and id=808)))

这样写哪里错了呢？报SQL命令未正确结束

[luckyzhangye]

自己先顶下。。

[metsys]

在最前面加个 select

[luckyzhangye]

[Quote=引用 2 楼 metsys 的回复:]
在最前面加个 select
[/Quote]
未找到要求的FROM关键字

[oxcow]

Oracle:

select 

(SELECT   COUNT ( * )
   FROM   t_familymember tf
  WHERE   tf.familyid IN
                (SELECT   familyid
                   FROM   t_publicrentcontract
                  WHERE   operationtype = 3
                          AND familyid IN
                                   (SELECT   id
                                      FROM   t_familybasicinfo
                                     WHERE   county = 305 AND id = 808)))


*

( (SELECT   COUNT ( * )
     FROM   t_publicrentcontract
    WHERE   operationtype = 3
            AND familyid IN (SELECT   id
                               FROM   t_familybasicinfo
                              WHERE   county = 305 AND id = 808)))
                              
from dual      

[luckyzhangye]

[Quote=引用 4 楼 oxcow 的回复:]
Oracle:

SQL code
select

(SELECT COUNT ( * )
FROM t_familymember tf
WHERE tf.familyid IN
(SELECT familyid
FROM t_publicrentcontract
……
[/Quote]
谢谢大侠！！

[janoelives]

你先从你语句的最后看 如果select 出的结果是"集" 那还乘个屁..- -..

[oxcow]

mysql

select 

(SELECT   COUNT ( * )
   FROM   t_familymember tf
  WHERE   tf.familyid IN
                (SELECT   familyid
                   FROM   t_publicrentcontract
                  WHERE   operationtype = 3
                          AND familyid IN
                                   (SELECT   id
                                      FROM   t_familybasicinfo
                                     WHERE   county = 305 AND id = 808)))


*

( (SELECT   COUNT ( * )
     FROM   t_publicrentcontract
    WHERE   operationtype = 3
            AND familyid IN (SELECT   id
                               FROM   t_familybasicinfo
                              WHERE   county = 305 AND id = 808)))