For example:
A master table a
A schedule b
A multiple b

So I need to statistics a number of the status and the corresponding status

But a status from a correlation of b in a status as a latest status

Considered is

Taking the latest id left connection and then link to check the status again statistics

Feel the more troublesome, is there a simple way, the database is MySQL

CodePudding user response:

You should take from b, each a last valid data to link a table for detailed information