请教各位:
SELECT ShortName, companyGUID
FROM dbo.Company
WHERE not EXIST(SELECT AllowReadGuid FROM dbo.PermissionRead WHERE dbo.Company.companyGUID = AllowReadGuid)
为何老是报错!
消息 156,级别 15,状态 1,第 3 行
关键字 'SELECT' 附近有语法错误。
无法绑定有多个部分组成的标识符"dbo.Company.companyGUID "
not?exist
------解决方案--------------------
SELECT ShortName, companyGUID
FROM dbo.Company
WHERE not exists(SELECT AllowReadGuid FROM dbo.PermissionRead WHERE dbo.Company.companyGUID = AllowReadGuid)