Thanks for your help.

I've actually used the solution given to me in another forum and it seems to work:

SELECT TicketID,
Date,
Category,
Status
FROM (
SELECT TicketID,

Hi,

I'm having trouble building the correct syntax select statement for a system to handle support tickets.

The table "tickets" has the following columns:

id (int)
inserted...