you should be able to join on same table.
select b.id,b.name,b.type,b2.name as bossname from users b
left join users b2 on b.bossid = b2.id
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Sep 16, 2008, at 3:12 PM, Tom Ferguson wrote:
But maybe my brain is just frozen...
I have a User Table with different types of users. Some of the
users are
bosses and some of the users are workers.
User Table
ID
Name
Type (boss or user)
BossID
The BossID contains the ID of the boss' record.
I have a typical taf built from the search builder.
In the RecordDetail when I'm displaying the Worker's information, I
want to
display his boss' name instead of his boss' ID. How do I do that.
If the
boss' name was in a different table, it would be a snap.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
