I've got a strange query question for you SQL experts:
I've got two tables: Users and Divisions. Each User has one Division (linked
by a field on the user), and each division has a director (linked by a field
on the division).
How can I write a query to return all the users and their division heads
(Users --> Divisions --> Users). I'm using MySQL, so subselects are out. Any
other ideas?
Thanks!!!
Norman Elton
Information Technology
College of William & Mary
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
