Quote Originally Posted by r937 View Post
Code:
SELECT m, MAX(maxDateTime) AS latest
  FROM ( put your UNION query here ) AS u
GROUP BY m
The code below produces an Error.

Code:
SELECT m, MAX(maxDateTime) AS latest
  FROM  m1 as m union m2 as m  AS u
GROUP BY m
I guess I never did UNION in FROM clause before.
Where should I put myTable name "journal" inside red part?