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