Re: Help with a JOIN.

Funny how reading one's own email is helpful! :-)

The answer of course is

SELECT t.ticket_id, t.ticket_description, x.c_com_id, z.comments_comment
FROM
(
SELECT ticket_id, MAX(c.comment_id) AS c_com_id
FROM comment c
WHERE c.comments_timestamp < UNIX_TIMESTAMP(NOW() - INTERVAL 2 YEAR)
GROUP BY ticket_id
)
AS x INNER JOIN ticket AS t ON t.ticket_id = x.ticket_id
INNER JOIN comment AS z ON z.comment_id = x.c_com_id;

i.e. using the comment_id as the discriminator - which I actually
*_wrote_*, but was
unable to apply until I'd reread my own email. Funny thing the mind (well,
mine anyway! :-) ).

Thanks to the list and esp. Ken.

Rgs,

Paul...

--

linehanp(at)tcd(dot)ie

Mob: 00 353 86 864 5772