When people create a 'ticket' the subject goes into the tickets table and the message and everything else goes into the tickets_replies table.
They are joined with tickets.id = tickets_replies.ticket_id .
SELECT tickets.subject, tickets_replies.reply, `tickets_replies.when` as replied_date FROM `tickets`, `tickets_replies` INNER JOIN tickets ON tickets.id=tickets.ticket_id WHERE `tickets.id`='$id' AND ORDER BY `tickets_replies.when`
However, i get the error: Not unique table/alias: 'tickets'. I don't see how it isn't unique, thats the table name and there isn't a field called that!
Thanks in advance.