Question

sql 多表关联查询，看下这句sql哪里错了，高手进，在线等！！！！

SELECT * FROM aaa as t1 JOIN ((SELECT count(*) from bbb where sid=t1.sid) as jieguo) as t2 WHERE t2.jieguo > 0

Answer 1

你语法就错了。 你的T1表 和T2表 关系呢？下面是语法。 你的on后面关系没写，且 你第二张表只有汇总字段 ，这怎么能关联！
select * from T1 join T2 on T1.code=T2.code

改成如下写法

SELECT * FROM aaa as t1 JOIN ((SELECT count(*) as jieguo，sid from bbb Group by sid) as jieguo) as t2 on T1.sid=t2.sid WHERE t2.jieguo > 0

追问

也报错啊

追答

SELECT * FROM aaa as t1 JOIN ((SELECT count(*) as jieguo,sid from bbb Group by sid) as jieguo) as t2 on T1.sid=t2.sid WHERE t2.jieguo > 0

逗号问题

Answer 2

jieguo=t2=count（*）是一个数字吧

追问

是啊

Answer 3

把 sid=t1.sid改为jieguo.sid=t1.sid，如下：
SELECT * FROM aaa as t1 JOIN ((SELECT count(*) from bbb where jieguo.sid=t1.sid) as jieguo) as t2 WHERE t2.jieguo > 0;

追问

不行啊，还是报错