fankaifeng commented on issue #28966:
URL:
https://github.com/apache/shardingsphere/issues/28966#issuecomment-1798069279
SELECT count(1)
FROM user_customer_relation_126 ucr join customer_126 c on
ucr.customer_id = c.id
WHERE c.`is_deleted` = 0
AND ucr.tenant_id = 144
AND ucr.user_id = 94
AND ucr.customer_id IN (
select ctm.customer_id
FROM customer_tag_mapping_16 ctm
WHERE ctm.tenant_id = 144 and ctm.tag_id IN
(
1232
)
GROUP BY ctm.customer_id HAVING COUNT(*) = 1
) , similar question ，query all sharding tables
user_customer_relation_0~127 ，expect only table user_customer_relation_16
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
