select top 24 * from movieinfo where [MID] NOT IN (select top 6 MID from movieinfo where MIndex=1 and MTypeID between 10 and 13 )你这里查出的元组是不满足 MIndex=1 and MTypeID between 10 and 13 的那些而你后面又查询满足and MIndex=1 and MTypeID between 10 and 13当然就没有符合要求的元组了not in 后面是可以加其它条件的不妨你试试
除了一楼所说的问题外~似乎这句会报语法错误:select top 24 * from movieinfo where [MID] NOT IN (select top 6 MID from movieinfo where MIndex=1 and MTypeID between 10 and 13 )and MIndex=1 and MTypeID between 10 and 13你括号里面的top会报语法错误:Incorrect syntax near the keyword 'top'. 去掉括号里的top查一下返回结果集为空,表示没有符合要求的元组