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@tcd.ie Mob: 00 353 86 864 5772