Yes it is possible and you only need to use LEFT join if you need all of
the records from "issues" whether there are records in users that match or
not.
Just JOIN the users table TWICE and assign each one it's own alias, like
this:
SELECT ....
FROM issues i
INNER JOIN users u1
on u1.id = i.iuserid
INNER JOIN users u2
on u2.id = i.iuserid2
WHERE ....
Use the qualified name to get column values from a particular table:
u1.username, i.issuenumber, u2.phonenumber, etc.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Doug Wolfgram <[EMAIL PROTECTED]> wrote on 09/13/2004 01:26:33 PM:
> I have a table called issues and other table called users. Issues
contains
> two fields that are in effect userids that reference the users table. I
> want to produce a report with a single query that grabs the names of
both
> users referenced in the issues table. Is this possible?
>
> I knwo how to do this for a single userid...
>
> select u.firstname FROM users u, issues i WHERE u.id=iuserid
>
> etc...
>
> But I need to get two names at the same time...will some version of left
> join work?
>
> D
>
>
> _________________________________________
>
> "If you're not in e-business ... you're not in business.."
> _________________________________________
>
> Doug Wolfgram
> GRAFX Group, Inc.
> Cell: 949.433.3641
> http://www.gfx.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
