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