sql server2008 left outer join 大神们检查下
select
this_.uid as 用户id,
this_.rid as 角色id_,
this_.uname as 用户名_,
this_.password as 密码,
this_.bith as 生日,
this_.pic as 图,
role2_.rid as 角色id2_,
role2_.rname as 角色名_
from
sj303.dbo.users this_
left outer join
sj303.dbo.role role2_
on this_.rid=role2_.rid
where
this_.uname like '三%'
and this_.bith like '2013-11-21%'