这样的sql语句怎么写啊????
SQL code
要求返回这样的结果
SQL code
id reid topid name 1 0 0 a 2 1 1 b 3 2 1 c 4 2 1 d 5 2 1 e 6 1 1 f 7 6 1 g
要求返回这样的结果
SQL code
id reid topid fullname 3 2 1 abc 4 2 1 abd 5 2 1 abe 7 6 1 afg
作者: zyk220 发布时间: 2011-06-08
SELECT a.id,a.reid,a.topid,concat(a.name,b.name,b1.name) as fullname
from tt a left join tt b on a.topid=b.id
left join tt b1 on a.reid=b1.id
where a.topid>=1 and a.reid>1 and b.reid=0 and b.topid=0 and b1.reid=1 and b1.topid=1
from tt a left join tt b on a.topid=b.id
left join tt b1 on a.reid=b1.id
where a.topid>=1 and a.reid>1 and b.reid=0 and b.topid=0 and b1.reid=1 and b1.topid=1
作者: wwwwb 发布时间: 2011-06-08