MySQL query satisfies three conditions one is the maximum time of all rows

MySQL query satisfies three conditions where one is the maximum time of all rows
Tables table structure is as follows:


Query statement:
SELECT * FROM table WHERE dtime = (select Max (Dtime) from final) and customer = ' Test ' and nbname = ' Dell XPS 13 '
We can't find anything.

But put the dtime= in the Where (...) This paragraph is removed and results come out.
After joining this paragraph, the results are not matched.
How to modify it.
------to solve the idea----------------------
What do you see in select Max (Dtime) from final?

