On Wed, 03 Jul 2002 21:09:24 +0200, I wrote:
>select MESSAGE.BOARD_ID
> , [...]
> , count(TH.THREAD_ID) as TFUID
Oops! COUNT won't work unless you add GRAOUP BY <all other fields> at
the end of the query. I had
CASE WHEN th.thread_id IS NULL THEN 0 ELSE 1 END
here and thoughtlessly replaced it by COUNT(...) for brevity. How
foolish!
Servus
Manfred