sql - 使用子查询在同一张表上左连接

Question

select *
from (select *
    from TableO to
    where to.week='22'
    and to.year='2018'
    ) as O 
   left join TableO lto on O.user_id=lto.user_id
where O.user_id IS NULL

我遇到了这个查询的问题。谁能看到错误是什么？

我试图在同一张桌子上留下加入，试图找到这部分：

标签： sqlsql-server

Answer 1

SELECT userid FROM TABLE1 
EXCEPT 
(SELECT userid FROM Table2 INTERSECT SELECT userid from table2)