Homerboy
Lifer
I have two queries, one queries against the DIARYINT table and the other against the ACTIVE table. Each are group by employer number.
What I want to do is JOIN these two into ONE table so that I have all my employees each in a row and then the 10 columns from ACTIVE query and 5 columns from the DIARYINT query. I thought I could use Merge Task, but that doesn't seem to be working (or I am doing it wrong) as it is giving me two rows for each employee... one with the ACTIVE data and the other with the DIARYINT (and filling in the other with NULL)
The number rows returned in the DIARYINT query may not be EXACTLY the same as the number of rows in the ACTIVE query. (in some cases out of the 60 employees, not all may have entries in the ACTIVE, or in the DIARYINT, but I want all rows represented.
Does that make sense?
What I want to do is JOIN these two into ONE table so that I have all my employees each in a row and then the 10 columns from ACTIVE query and 5 columns from the DIARYINT query. I thought I could use Merge Task, but that doesn't seem to be working (or I am doing it wrong) as it is giving me two rows for each employee... one with the ACTIVE data and the other with the DIARYINT (and filling in the other with NULL)
The number rows returned in the DIARYINT query may not be EXACTLY the same as the number of rows in the ACTIVE query. (in some cases out of the 60 employees, not all may have entries in the ACTIVE, or in the DIARYINT, but I want all rows represented.
Does that make sense?
