Joins etc..

[king]

Hi, i have the following statement that does not work!

 

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.

[Marrvel]

try this:

 

SELECT
`t`.`subject`, `r`.`reply`, `r`.`when` as `replied_date`
FROM
`tickets_replies` as `r`
INNER JOIN
`tickets` as `t` ON `t`.`id`=`r`.`ticket_id`
WHERE
`t`.`id`='$id' AND
ORDER BY
`r`.`when`