The sum of the recent m1Bs or m2Bs

[r937]

table u and table journal.

wrong

[dotJoon]

wrong

u and d?

(I tried all combinations of table journal, table u and table d.
But all of them causes an error.)

[r937]

you're floundering

stop guessing and go back to post #47

[dotJoon]

stop guessing and go back to post #47

The code below also causes an ERROR

FROM (
        SELECT m, MAX(maxDateTime) AS latest
          FROM (
               select m1 as m, max(dateTime) as maxDateTime
                 from journal
               group by m1
               union
               select m2 as m, max(dateTime) as maxDateTime
                 from journal
               group by m2 
               ) AS u
        GROUP BY m
        ) AS d
INNER
  JOIN journal on journal.time=u.latest

[r937]

i am sure if you look at it long enough, you will see what the problem is

go back and re-read posts #49, #50, and #51

[dotJoon]

which two tables are being joined?

table u and table d?

[r937]

clearly you do not understand what you are doing

i suggest you re-read the entire thread

[dotJoon]

i suggest you re-read the entire thread

I suggest you give me it in SQL.
This is beyond my boundary at the time.

[r937]

I suggest you give me it in SQL.

no, i will not

i've been giving you SQL for years, joon

it is time that you learn how to do it yourself

sorry, but that's the way it has to be from now on

[dotJoon]

no, i will not

i've been giving you SQL for years, joon

it is time that you learn how to do it yourself

sorry, but that's the way it has to be from now on

Then, I think you should give me more detailed hint.

[r937]

for detailed hint, see post #43

[dotJoon]

for detailed hint, see post #43

You said it several time. I reRead it hundreads of time.
Now your saying is useless like my reReading is useless.