列名 'price' 无效。Select Top 15 * From [shop_company] Where [ID] Not IN ( Select Top 44430 [ID] From [shop_company] Where [Display]=1 and [cid] in (2,15,16,33,17) Order By price asc ) and [Display]=1 and [cid] in (2,15,16,33,17) Order By price asc