SELECT * FROM msg.*,dict_msg.mname FROM MSG,dict_msg
WHERE msg.mtype=dict_msg.mtype AND mauthor='小王' AND MSG.MID IN (
SELECT DISTINCT MID FROM user_um AS A WHERE NOT EXISTS (SELECT * FROM user_um WHERE MID=A.MID AND isread=1))
WHERE msg.mtype=dict_msg.mtype AND mauthor='小王' AND MSG.MID IN (
SELECT DISTINCT MID FROM user_um AS A WHERE NOT EXISTS (SELECT * FROM user_um WHERE MID=A.MID AND isread=1))
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货