select TOP 4*from Examine where ExamineLevel in(select LinkLevel from Link where
LinkClubId=3) and ExamineTypeId in(select LinkExamineTypeId from
Link where LinkClubId=3 )and ExamineId not in( SELECT TOP (4*0) ExamineId FROM Examine )
如果改成not in 呢
select TOP 4*from Examine
where ExamineLevel
not in(select LinkLevel from Link where
LinkClubId==3) --not in 把where条件改成不等于3就好啦
and ExamineTypeId
not in(select LinkExamineTypeId from Link
where LinkClubId==3 ) --not in 把where条件改成不等于3就好啦
and ExamineId not in( SELECT TOP (4*0) ExamineId FROM Examine )追问
where ExamineLevel
not in(select LinkLevel from Link where
LinkClubId==3) --not in 把where条件改成不等于3就好啦
and ExamineTypeId
not in(select LinkExamineTypeId from Link
where LinkClubId==3 ) --not in 把where条件改成不等于3就好啦
and ExamineId not in( SELECT TOP (4*0) ExamineId FROM Examine )追问
我问的是linq怎么写
温馨提示:答案为网友推荐,仅供参考