Solved! Go to Solution.
try something like below
select wtm.name,wtm.wtpartnumber,wtd.logicalidentifier from wtpart wt,wtpartmaster wtm,wttypedefinition wtd
where wt.ida2typedefinitionreference =wtd.ida2a2 and wtm.ida2a2=wt.ida3masterreference and wtm.wtpartnumber like '0000001821'
try something like below
select wtm.name,wtm.wtpartnumber,wtd.logicalidentifier from wtpart wt,wtpartmaster wtm,wttypedefinition wtd
where wt.ida2typedefinitionreference =wtd.ida2a2 and wtm.ida2a2=wt.ida3masterreference and wtm.wtpartnumber like '0000001821'
Nice thank you!