select D.EMPLOYEENO,
D.EMPLOYEENAME,
D.DATECOMP,
D.ACTHOURS0,
DM.DMID,
DM.DESCRIPT,
DM.EQUIPNO
from LABORAD D, DMACTIVE DM
where DM.DMID = D.DMID
UNION ALL
select HD.EMPLOYEENO,
HD.EMPLOYEENAME,
HD.DATECOMP,
HD.ACTHOURS0,
DM.DMID,
DM.DESCRIPT,
DM.EQUIPNO
from LABORHD HD, DMACTIVE DM
where DM.DMID = HD.DMHID
UNION ALL
select P.EMPLOYEENO,
P.EMPLOYEENAME,
P.DATECOMP,
P.ACTHOURS0,
PM.PMID,
PM.DESCRIPT,
PM.EQUIPNO
from LABORAP P, PMACTIVE PM
where PM.PMID = P.PMID
UNION All
select HP.EMPLOYEENO,
HP.EMPLOYEENAME,
HP.DATECOMP,
HP.ACTHOURS0,
PM.PMID,
PM.DESCRIPT,
PM.EQUIPNO
from LABORHP HP, PMACTIVE PM
where PM.PMID = HP.PMHID;
This is the query I'm using but it is only picking up 1 entry from each table.
Anyone have any ideas?
Thanks
Carol