Exists

来源:互联网 发布:linux远程连接oracle 编辑:程序博客网 时间:2024/05/02 01:21
SELECT FirstName, ID, (CASE WHEN EXISTS
          (SELECT id
         FROM application
         WHERE Customer.id = Application.ID) THEN 'AA' END)
FROM Customer 
原创粉丝点击