left outer join 结合条件查询

之前一直这么用可都没有达到符合条件的记录。

select a.id,a.Usersname,a.Gcontent,a.GuestType,a.CreatTime,a.Checked,a.IpAddr
,b.MessId,b.Txtcontent
from fervor_guest as a 
left outer join 
replyMsg as b
on b.MessId=a.id
and a.GuestType='测试1'
order by a.id desc

 

 

select a.id,a.Usersname,a.Gcontent,a.GuestType,a.CreatTime,a.Checked,a.IpAddr
,b.MessId,b.Txtcontent
from fervor_guest as a 
left outer join 
replyMsg as b
on b.MessId=a.id
where a.GuestType='测试1' --改成这句就ok了。^_^
order by a.id desc