Temporary table?

Thu, 05 Jun 2014 20:31:06 GMT

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?

Re: Temporary table?

Colin-Albert — Thu, 05 Jun 2014 20:45:34 GMT

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