Jump to content


Photo

Joins etc..


  • Please log in to reply
1 reply to this topic

#1 king

king
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 19 September 2005 - 05:13 PM

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.

#2 Marrvel

Marrvel
  • Members
  • Pip
  • Newbie
  • 6 posts
  • LocationLondon

Posted 20 September 2005 - 07:36 PM

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`





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users