消息表message: id, title, fb_user_id(发布消息者的id)
用户表user: id, name
中间表message_user: id, message_id, user_id(接受消息者的id)
已有用户id=001;
查询此用户发布的消息(message.fb_user_id=001)以及接受的消息(message_user.user_id=001),用一条hql语句查询
求指导
select * from message m where m. fb_user_id=001 or m.id in (select message_id from message_user mu where mu.user_id=001)
你试试
select * from message m where m. fb_user_id=001 and m.id in (select message_id from message_user mu where mu.user_id=001)
or应该换成and 刚才写错啦