I will describe the issue as best I can!
I am not able to change the DB structure as it is a commercial DB.
Scenario: I have 2 tables, orders and consultants as follows
person2 Account manager
person4 Account manager
These tables are linked, the issue is when running the query i get the following
What I need to achieve is:
orderID Sales Account manager
1001 Person1 Person2
1002 person3 person4
Any pointers or help would be greatly appreciated
Many thanks in advance,