Anonymous

CTicket:

+----------+------------+
| TicketID | custID     |
+----------+------------+
|     1    | 10         |
|     2    | 5          |
+----------+------------+

CMsg:
+------+---------+-------------+--------------------+
| MsgID| Ticket  | Msg         | Timestamp          |
+------+---------+-------------+--------------------+
| 1    | 1       | msg1        |2006-07-06 00:00:00 |
| 2    | 1       | msg2        |2006-07-06 00:01:00 |
| 3    | 1       | msg3        |2006-07-06 00:02:00 |
| 4    | 2       | msg1        |2006-07-06 00:03:00 |
| 5    | 2       | msg2        |2006-07-06 00:04:00 |
| 6    | 1       | msg4        |2006-07-06 00:05:00 |
+------+---------+-------------+--------------------+

Is it possible using a select query to get to latest reply from cmsg using a join eg.

+----------+------------+--------------+
| TicketID | custID     | Msg          |
+----------+------------+--------------+
|     1    | 10         | msg4         |
|     2    | 5          | msg2         |
+----------+------------+--------------+