select top 10 PE_Company.CompanyName,PE_Company.Homepage,PE_User.GroupID from PE_Company,PE_User where PE_Company.CompanyID = PE_User.CompanyID AND NOT PE_User.IsLocked order by PE_Company.CompanyID desc不带条件AND NOT PE_User.IsLocked就没问题,PE_User.IsLocked是bit类型。