How to get those base master record id's progid, projid and contractid which are not matching.
hierarchy is progid - projid - contractid
want to check in my transaction table if any hierarchy combination is not matching.
transaction table is tab_ccsnetrm
hierarchy tables in sequence from top to bottom are 1.) tab_ccsnetprograms, 2.) tab_ccsnetprojects, 3.) tab_ccsnetcontracts.
can you please tell me, i have an issue within my transaction table non matching hierarchy id's happening randomly once in a while. want to get all rm.rmid which has the hierarchy wrong combination.
select rm.rmid, rm.progid, rm.projid, rm.contractid from TAB_ccsNetRM rm
inner join TAB_ccsNetContracts ctr on (rm.contractid=ctr.contractid)
inner join TAB_ccsNetProjects pj on(rm.projid=pj.ProjID)
inner join TAB_ccsNetPrograms pg on(rm.progid=pg.ProgID)
Thanks a lot for the helpful info.