hi there, i am a beginner when it comes to SQL and i have an issue which i struggle with for some time.
I have 2 tables: in table1 i have columns: teritory group name, territory member name, territory group ID
in table 2: teritory group name, territory group ID and sales rep.
I need to bring the sales repes from table 2 to table 1 based on the territory ID. My problem is that territory group name can have many territory member name. Lets say for example that in table 1 i have for territory group name=emea i have 4 territory member name: france, germany, italy and spain. and territory group ID =101
in table2 for territory group ID=101 i have 3 sales reps: ana, mary and cami. i need to brong those selas reps from table 2 to table 1 and each of them to have all 4 territory member name.
i left joined those 2 tables but its not right because i need those rows to be multiplied for each sales rep.
i would really apreciate your help.