hi,
I have two queries, named:
1. Q1, which has columns name
Mgr ID, MGR_Name, Empl_ID, Empl_Name, Years_of_Service
and
2.Q2 which has
MGR_ID, EE count
both queries have 1:1 relationship for MGR_ID
Using this two queries, I'd like to output a table like this:
The empl_name with respective MGR_ID will be automatically feed to columns named GAR1 until GAR 6 and the respective years_of_service will be feed to GAR 7 - GAR 13 columns accordingly.
Can anyone help me?