34,588
社区成员
发帖
与我相关
我的任务
分享
select *
from Sys_NoticeList A
left join
(select * from Sys_User_NoticeList where uid=1) B on A.id=B.msgid
SELECT id,
title,
message,
createTime,
uid,
msgid,
state
FROM Sys_NoticeList
LEFT JOIN Sys_User_NoticeList
ON Sys_NoticeList.id = Sys_User_NoticeList.msgid;