set的类型要正确才行吧? select * from ? 可能会被解释成select * from 'aa'
? 出现的地方应当是某个量的值而非某个量的名比如 from 后面就是名而非值,同样,别名也不能用?而一般where里面,因为都是在进行值比较,所以这里才是?通常出现的地方
select (select count(*) from TBLMEMBER where year(MDATE) = ? and month(MDATE) = ?) as CUR_MONTH_MEMBER_CNT, (select -1) as ACTIVE_MEMBER_CNT, (select count(*) from TBLMEMBER) as ALL_MEMBER_CNT, (select count(*) from TBLMEMBER) as ALL_MEMBER_CNT没看懂这句为什么不行,不知报什么错,难道是最后的别名相同?
select * from ? 可能会被解释成select * from 'aa'
(select count(*) from TBLMEMBER where year(MDATE) = ? and month(MDATE) = ?) as CUR_MONTH_MEMBER_CNT,
(select -1) as ACTIVE_MEMBER_CNT,
(select count(*) from TBLMEMBER) as ALL_MEMBER_CNT,
(select count(*) from TBLMEMBER) as ALL_MEMBER_CNT没看懂这句为什么不行,不知报什么错,难道是最后的别名相同?