Philky101
asked on
Ibm i View - may be creating Duplicate Records
I am seeing what seems to be duplicate records from this view. Do you think this View is causing duplicate records?
create view astccdta.acaudia AS
( select d.IARCC9,b.ItQty#,a.IhDocd ,b.ItPRT#
from astdta.OEINHDIH a
join astdta.ICDETLIT b on
b.Itcom# = a.IhCom#
and
b.ItTrn# = a.IhIdc#
left join astdta.ICECTLCT c on
c.CtCom#= b.ItCom# and
c.CtCtr# = ' ' and
c.CtPrt# =b.ItPrt#
left join astdta.Audia d
on d.IAprt# = b.ItPrt#
where b.ItTscc = 'I' and a.IHDOCD > 20120105
and d.IARCC9 > ''
)
create view astccdta.acaudia AS
( select d.IARCC9,b.ItQty#,a.IhDocd
from astdta.OEINHDIH a
join astdta.ICDETLIT b on
b.Itcom# = a.IhCom#
and
b.ItTrn# = a.IhIdc#
left join astdta.ICECTLCT c on
c.CtCom#= b.ItCom# and
c.CtCtr# = ' ' and
c.CtPrt# =b.ItPrt#
left join astdta.Audia d
on d.IAprt# = b.ItPrt#
where b.ItTscc = 'I' and a.IHDOCD > 20120105
and d.IARCC9 > ''
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It would help greatly if you posted a sample of the data your seeing .... plus a sample of what you expected to see.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Philky101, it's been a month and a half since you asked this question, and it's been about a month since the last response.
Is this still an issue? Did you get your problem resolved? If so, how?
-- DaveSlash
Is this still an issue? Did you get your problem resolved? If so, how?
-- DaveSlash