Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
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!