Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've three tables with different information.
The sales table and staff table are mapped with "sales_per_id"
Customer and sales table are mapped with cust_name
Now i want to show the name of the account_manager (last example) where i get an overview of all the customer that they are responsible for..
Can i load the Staff table names to an temporary table and map it with the account manager id? How do i do that?
Customer Info | ||||
Cust_ID | Cust_name | Account_Manager_ID | ||
1 | Apple | 72 | ||
2 | Banana | 72 | ||
3 | Kiwi | 56 | ||
Sales | ||||
Cust_ID | Cust_name | Sales_Total | Sales_cost | Sales_per_ID |
1 | Apple | 1000 | 200 | 56 |
1 | Apple | 500 | 200 | 72 |
2 | Banana | 300 | 50 | 56 |
2 | Banana | 200 | 60 | 72 |
3 | Kiwi | 200 | 100 | 72 |
3 | Kiwi | 700 | 400 | 56 |
Staff | ||||
Sales_per_ID | Sales_name | |||
56 | Adam | |||
72 | James | |||
Account mangager | Customer | Sales | Cost | |
James | Apple | 1500 | 400 | |
James | Banana | 500 | 110 | |
Adam | Kiwi | 900 | 500 |
Load the staff data again into another table naming the fields Account_Manager_ID and Manager_Name.
Load the staff data again into another table naming the fields Account_Manager_ID and Manager_Name.