Query with different names in the same row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I got a table where I have the names of department chief and sub-chief.
How can I make a query that shows me on the same row both names of the chief
and sub-chief of each department.

Thanks in advance.

David
 
David

If you are saying that you have a table that has PersonName (only one, not
one for each role), AND if you have some way that you've shown the
role/relationship of one person to another (another table with the PersonIDs
and a role/relationship), then you can create a query, add the Person table
twice, add the "role" table once, and join them together so the Person-has a
role in relation to-the second Person.
 
Back
Top