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 ...