On 7 Jun 2006, at 18:56, Peter Brawley wrote:
Join users a second time for bugs.submitter, eg ...
SELECT
bugs.id, bugs.title, UNIX_TIMESTAMP(bugs.submitted), bugs.fix,
bugs.assignee,
users.username,
users2.username AS Submitter,
bugs.category,
category.name,
bugs.version,
version.nam
Geoffrey,
>SELECT
> bugs.id, bugs.assignee, users.username, bugs.submitter
>FROM fb_bugs AS bugs,
>fb_users AS users
>WHERE users.id = bugs.assignee
>My problem is that I also want the users.username for bugs.submitter.
How can I do that?
Join users a second time for bugs.submitter, eg ...
I've got the following query:
SELECT `bugs`.`id`, `bugs`.`assignee`, `users`.`username`,
`bugs`.`submitter` FROM `fb_bugs` AS `bugs`, `fb_users` AS `users`
WHERE `users`.`id` = `bugs`.`assignee`
My problem is that I also want the `users`.`username` for
`bugs`.`submitter`. How can I do tha