" select pins, id, name, project_id, testtime from (select id, name, pin the from user where group number='20210501') left the join (select user_id, project_id, testtime from score where project_id=2 and datetime (testtime) & gt;=a datetime (' 2021-05-04 08:00:00) and datetime (testtime) & lt; Datetime (' 2021-05-05 17:00:00) group by user_id) on pin=user_id where project_id is NULL order by pins
"QDebug () output:
Perform produce record article 15:
Record contents:
However, in the DB Browser for SQLite validation in this statement, the results are as follows:
This is pure inconsistent!
As the beginning of the result is good, also do not know how, become like this!
Which tall person can tell the mystery are there?
CodePudding user response:
Come on, don't look at, very lengthy statement,Problem solved, that is, restart the computer,
Feel QT's changes in perception often slow a beat, that kind of life without perception scare me just now: I thought it was what the big deal,