Ask a forum for short message mass SQL statements.

Above is Discuz's short message mass data table, how to query the user did not read the short message it?

Reply to discussion (solution)

SELECT * From user record table A INNER JOIN message table B on a.gpmid=b.id where a.status=0

SELECT * From user record table A INNER JOIN message table B on a.gpmid=b.id where a.status=0

I'm sorry, but I don't know the description.
I mean, query for short messages that are not read by each user,
That is, a user does not show up after reading, but if B user does not read it will be displayed.

I do not know how your data is step, it is recommended to post test data and expected results, and briefly describe the logical relationship.

Selece uid pre_common_member_grouppm where status=0
Will get all the users who read the short message
As to how to do in the future, it is up to you to decide, I can not agents

