这个语句能改进吗SELECT t1id FROM test t1 test t2 test t3 WHERE t1value2+10 = t2value2 and t2value1+t2value2 = t3value2

可以将多个表的连接改写为使用JOIN关键字，使语句更加清晰和易读：

SELECT t1.id FROM test t1 JOIN test t2 ON t1.value2+10 = t2.value2 JOIN test t3 ON t2.value1+t2.value2 = t3.value2

原文地址: https://www.cveoy.top/t/topic/bsoB 著作权归作者所有。请勿转载和采集!