|
anishap
Yak Posting Veteran
61 Posts |
 Posted - 10/26/2012 : 14:46:14
|
I'm trying to join 2 datasets in SSRS but I don't know if there is any way to do is.
Below is the query Dataset1
SELECT E.FLDID,E.FLDLNAME,E.FLDFNAME,D.FLDDESCR AS DEPT,J.FLDDESCR AS JOB,E.FLDEMAIL,I.FLDDATE,I.FLDTYPE,I.FLDSTATUS
FROM EMPLOYEE E LEFT OUTER JOIN IMMUNE I
ON E.FLDREC_NUM = I.FLDEMPLOYEE
LEFT OUTER JOIN DEPT D
ON D.FLDCODE = E.FLDDEPT
LEFT OUTER JOIN JOB J
ON J.FLDCODE = E.FLDJOB
WHERE I.FLDDATE >= '2012-07-01' AND I.FLDTYPE IN ('109','111')
ORDER BY E.FLDLNAME, E.FLDDEPT
Dataset 2 (is on Access database)
I just want to join the employee table in dataset2 to the above query on dataset1.
Is this possible?
**********************************
For example DATASET1.EMPLOYEE.EID = DATASET2.EMPLOYEE.ID
|
|
Multiple Datasets
