SQL_ID 99tfs2tpapwqk, child number 0
-------------------------------------
select count(*) num from ( select a.*, b.client_name client_name2,
a.err_msg err_msg2 from tbtranscfm a inner join tbclient b on
a.in_client_no = b.in_client_no inner join tbtainfo c on c.ta_code =
a.ta_code where a.bank_acc= :1 and (a.prd_code in ( select prd_code
from tbproduct where dep_id <> dep_id and ta_code='LF' and model_flag
<> '1' union select temp_b.prd_code from tbdataaccess_dep temp_a
inner join tbproduct temp_b on temp_a.prd_code=temp_b.prd_code where
temp_a.dep_id='' and temp_a.reserve1 like '1%' and ta_code='LF' and
model_flag <> '1' union select
sql 字符串 数值型不走索引
最新推荐文章于 2023-05-02 18:30:13 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)