Hi André Arnaud de Calavon,
Yes I did, I trace from personalize form and finally get the sql query but have a duplicate row
select InventTable.AGSItemGroupId,INVENTTABLE.ITEMID,ECORESPRODUCTTRANSLATION.NAME, ROUTEVERSION.ROUTEID,cap.NAME,cap.DESCRIPTION from
WRKCTRACTIVITY act inner join
WRKCTRACTIVITYREQUIREMENTSET reqSet on act.RECID = reqSet.ACTIVITY inner join
WRKCTRACTIVITYREQUIREMENT req on reqSet.RECID = req.ACTIVITYREQUIREMENTSET
inner join WRKCTRACTIVITYCAPABILITYREQUIREMENT capReq on
req.RECID = capReq.ACTIVITYREQUIREMENT
inner join WRKCTRCAPABILITY cap on capReq.CAPABILITY = cap.RECID inner join
WRKCTRROUTEOPRACTIVITY oprAct on act.RECID = oprAct.ACTIVITY inner join
ROUTEOPR roOpr on oprAct.ROUTEOPR = roOpr.RECID inner join
INVENTTABLE on roOpr.ITEMRELATION = INVENTTABLE.ITEMID inner join
ROUTETABLE on roOpr.ROUTERELATION = ROUTETABLE.ROUTEID inner join
ROUTEVERSION on ROUTETABLE.ROUTEID = ROUTEVERSION.ROUTEID inner join
ECORESPRODUCTTRANSLATION on INVENTTABLE.PRODUCT = ECORESPRODUCTTRANSLATION.PRODUCT
Is there any wrong relation on my sql query?
Regards,
Bintang
