Inserting data from two places into a single table
Posted 07 August 2006 - 03:30 PM
I am getting the date, sales and department id from one place and then I am getting the operating hours and operating wages from another department.
The major problem that I am having is that the place where I am getting the hours and wages from has some departements that the sales won't have and then the sales will have some departments that the hours and wages wont....does this mean I just need to make another table to store sales in one and wages and hours in another?
Posted 07 August 2006 - 03:35 PM
SELECT * FROM table1 AS t1 LEFT JOIN table2 AS t2 ON t1.department_id=t2.department_iddo it?
Posted 07 August 2006 - 04:46 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users