I'm using MySQL 3.21.33b so is this possible...
I have 2 tables (items and people). Two of the columns in the items table are
assigned_to and originator which contain usernames which happen to link to the people
table. The people table has their first and last names among other things. What I
was trying to do is some how get the first and last name for both the originator and
the assigned_to columns
I suppose I could just run two queries. One for the originator and one for the
assigned_to using a query similar to the one below...but I was wondering if there is a
way to do it in one query.
select concat(lname,', ', fname,' (',originator,')')
from items, people
where people.uid = items.originator
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
