62,041
社区成员
发帖
与我相关
我的任务
分享
selct *from User u
inner join Examine e on u.userid=e.userid and IsExam='1'
inner join AdminId a on e.adminid=a.admin
selct *from User u
inner join Examine e on u.userid=e.userid and IsExam='1
inner join AdminId a on e.adminid=a.admin
select UserId from Examine where IsExam='1' AdminId=(
select AdminId from Admin
//总感觉上面少了个and 或or
select UserId from Examine where IsExam='1' and(或or) AdminId=(
select AdminId from Admin
select [User].* from [User],Examine
where [User].UserId=Examine.UserId and Examine.IsExam='1'
and exists (select 1 from [Admin] where Examine.AdminId=[Admin].AdminId)