select xs.xm,a.bjname from cj,xs right join (select * from bj where bj.id in(29,30,31)) as a on xs.bjid=a.id where xs.id=cj.xsid and cj.ksid=53 and (cj.kcid90)>=0 and (cj.kcid90)>=25 and (cj.kcid90)<100 and xs.ztid not in(51) group by a.bjname想实现把所有的bj.id in(29,30,31)中的bj.bjname都列出来,但现在只能列出bj.id=29的记录
right join 好像失效了,请高人指点下
right join 好像失效了,请高人指点下
right join bj on xs.bjid=bj.id
where cj.ksid=53 and (cj.kcid90)>=0 and (cj.kcid90)>=25 and (cj.kcid90) <100
and xs.ztid not in(51) and bj.id in(29,30,31)
group by a.bjname没有看到记录,优化了一下