![]() |
#2
cai4105795172013-11-23 10:47
|
只有本站会员才能查看附件,请 登录
只有本站会员才能查看附件,请 登录
为什么取不不值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%'