I have two tables Ticket and Thread. They have TicketID in common. Thread has several rows with the same TicketID in them. I only want to join the ticket and threads table with the latest Thread_Date in the thread table. I am not sure of the query that is needed. That is the simple scope, but i need to query several other pieces of data from the ticket table but nothing special, if this matters.
Thanks,
Neil