Multi-select

Doug Wolfgram Mon, 13 Sep 2004 10:29:15 -0700

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?


_________________________________________

"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]

Multi-select

Reply via email to