Mark Alambar

> @zhoubin7您好，请将您的问题中文翻译成英文。 @zhaojinchao95 Hello, I have updated my question

> 请启用`sql-show`（[参考道具](https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding/)）并在日志中提供逻辑 SQL 和实际 SQL。 -- Logic SQL: SELECT IFNULL(sum(o.order_amount - o.refund_amount), 0.00) AS todayRealTimeTurnover, IFNULL(SUM(CASE WHEN ori.is_first_order = 1 THEN o.order_amount - o.refund_amount END), 0.00) AS todayFirstOrderTurnover, IFNULL(SUM(CASE WHEN...

@RaigorJiang 

@RaigorJiang hi,I removed the subquery of the in condition in the sql, and it worked normally

> @zhoubin7 这真是个好消息，感谢您的反馈。 > > 可能分片场景下的子查询需要开启联合查询，可以尝试配置 [sql-federation-type](https://shardingsphere.apache.org/document/current/en/user-manual/common-config/props/)。  The error occurred while setting parameters ### SQL: SELECT u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date,...

join All associated tables need to be configured with the binding table