Forum Discussion
Solved
Display multiple fields that reference 1 master table
I have 2 tables Customer Table Company Sales Mgr Acc Mgr Support Mgr Comp A 1 4 4 Comp B 2 3 3 Comp C 1 4 3 Staff Table ID Name 1 James H 2 Tan KK 3...
Thanks. Unpivot does the trick !
Hi gancw1 ,
Did Irwan 's suggestion help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.
If that also doesn't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng