No guarantees... you'd probably want to use join syntax too. But this should
help. ;)
select
user.name as user_name,
user.division as division,
head.name as division_head
from users user, divisions, users head
where
head.ID = divisions.head_user_ID AND
user.division_ID = divisions.division_ID
Ed
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]