SQL高级子查询 烟柳锁池塘 2021-11-01 88 阅读1分钟 SQL高级子查询 子查询效率低，而关联查询效率更高 -- CREATE TABLE stu(id INT(20)) SELECT a.*,b.* FROM stu AS a JOIN jiangjin AS b WHERE b.money in (1000) AND b.id=a.id
