Temporary table?

[#1]

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

[Colin-Albert · Accepted solution]

Load the staff data again into another table naming the fields Account_Manager_ID and Manager_Name.