shardingsphere是否支持下面的sql格式

Question

SELECT COUNT(1) FROM table1 
LEFT JOIN table2 ON table2.id = table1.id WHERE table1.time = (SELECT max(time) FROM table1 d WHERE ...) 
AND table1.id NOT IN (SELECT id FROM table3 WHERE ...)

Answer 1

把第二行的第一where改成and就可以

 
SELECT COUNT(1) FROM table1 
LEFT JOIN table2 ON table2.id = table1.id and table1.time = (SELECT max(time) FROM table1 d WHERE ...) 
AND table1.id NOT IN (SELECT id FROM table3 WHERE ...)