34,838
社区成员




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;