Hey ich bin noch relativ neu dabei und versuche mich gerade an SQL ran zu tasten; Wollte Abfragen auf einer Iseries IBM machen über MSQuery; ich hoffe ich kann diese Frage in diesem Forum stellen;
select * from
(
select * from
(
Select
vp00PF.vp00NVK, vp00PF.vp00NVKP,
vp00PF.vp00NVKPF1, vp00PF.vp00NVKPF2,
vp00PF.vp00NVKPF3, vp00pf.VP00WFKTME,
vp00pf.VP00BWARE, vp00pf.VP00DADT,
vp00pf.vp00BMEHD
From S1037717.HEWWSFILE.VP00PF VP00PF
WHERE (vp00PF.vp00SMDT=1) AND
(vp00PF.vp00SGB='002') AND
(vp00PF.vp00SHBR='002') AND
(vp00PF.vp00SABT='001') AND
((vp00pf.VP00WFKTME<>0) or
(vp00pf.VP00BWARE <>0) or
(vp00pf.VP00WANWME <> 0))
) tabellexyz
inner join
((
Select
MH00PF.MH00NVK, MH00PF.MH00NVKP, MH00PF.MH00NVKPF1, MH00PF.MH00NVKPF2,
MH00PF.MH00NVKPF3,
SUM (MH00PF.MH00BHFGWA) as HF_Anteil_2008
From S1037717.HEWWSFILE.MH00PF MH00PF
where
(MH00PF.MH00SMDT=1) AND
(MH00PF.MH00SGB='002') AND
(MH00PF.MH00SHBR='002') AND
(MH00PF.MH00SABT='001') AND
(MH00PF.MH00DABTB>200800) And
(MH00PF.MH00DABTB<200900) AND
(MH00PF.MH00SVORG=20) and
(MH00PF.MH00BHFGWA<>0)
group by
MH00PF.MH00NVK, MH00PF.MH00NVKP, MH00PF.MH00NVKPF1, MH00PF.MH00NVKPF2,
MH00PF.MH00NVKPF3
)A
on
MH00NVK=vp00NVK and
MH00NVKP=vp00NVKP and
MH00NVKPF1=vp00NVKPF1 and
MH00NVKPF2=vp00NVKPF2 and
MH00NVKPF3=vp00NVKPF3
) b
inner join
(
Select
MM00PF.MM00BRGWM
FROM S1037717.HEWWSFILE.MM00PF MM00PF
) c
on b.MH00NVK=c.MM00NVK and
b.MH00NVKp=c.MM00NVKp and
b.MH00NVKPF1=c.MM00NVKPF1 and
b.MH00NVKPF2=c.MM00NVKPF2 and
b.MH00NVKPF3=c.MM00NVKPF3 ) D
where not mh00nvk is null
select * from
(
select * from
(
Select
vp00PF.vp00NVK, vp00PF.vp00NVKP,
vp00PF.vp00NVKPF1, vp00PF.vp00NVKPF2,
vp00PF.vp00NVKPF3, vp00pf.VP00WFKTME,
vp00pf.VP00BWARE, vp00pf.VP00DADT,
vp00pf.vp00BMEHD
From S1037717.HEWWSFILE.VP00PF VP00PF
WHERE (vp00PF.vp00SMDT=1) AND
(vp00PF.vp00SGB='002') AND
(vp00PF.vp00SHBR='002') AND
(vp00PF.vp00SABT='001') AND
((vp00pf.VP00WFKTME<>0) or
(vp00pf.VP00BWARE <>0) or
(vp00pf.VP00WANWME <> 0))
) tabellexyz
inner join
((
Select
MH00PF.MH00NVK, MH00PF.MH00NVKP, MH00PF.MH00NVKPF1, MH00PF.MH00NVKPF2,
MH00PF.MH00NVKPF3,
SUM (MH00PF.MH00BHFGWA) as HF_Anteil_2008
From S1037717.HEWWSFILE.MH00PF MH00PF
where
(MH00PF.MH00SMDT=1) AND
(MH00PF.MH00SGB='002') AND
(MH00PF.MH00SHBR='002') AND
(MH00PF.MH00SABT='001') AND
(MH00PF.MH00DABTB>200800) And
(MH00PF.MH00DABTB<200900) AND
(MH00PF.MH00SVORG=20) and
(MH00PF.MH00BHFGWA<>0)
group by
MH00PF.MH00NVK, MH00PF.MH00NVKP, MH00PF.MH00NVKPF1, MH00PF.MH00NVKPF2,
MH00PF.MH00NVKPF3
)A
on
MH00NVK=vp00NVK and
MH00NVKP=vp00NVKP and
MH00NVKPF1=vp00NVKPF1 and
MH00NVKPF2=vp00NVKPF2 and
MH00NVKPF3=vp00NVKPF3
) b
inner join
(
Select
MM00PF.MM00BRGWM
FROM S1037717.HEWWSFILE.MM00PF MM00PF
) c
on b.MH00NVK=c.MM00NVK and
b.MH00NVKp=c.MM00NVKp and
b.MH00NVKPF1=c.MM00NVKPF1 and
b.MH00NVKPF2=c.MM00NVKPF2 and
b.MH00NVKPF3=c.MM00NVKPF3 ) D
where not mh00nvk is null
Comment