$stmt= "

Select level, 
CWTM.wtpartnumber,
CWTM.name,
LINK.ida3b5,
CWTM.ida2a2, 
CWTP.versionida2versioninfo, 
LINK.amountA7 

from wtpartmaster CWTM, 
wtpartmaster AWTM, 


SELECT * FROM WTPART p1 
WHERE 
p1.latestiterationinfo = 1 AND 
p1.versionida2versioninfo = (select max(versionida2versioninfo) 
from WTPART p2 
where p2.ida3masterreference = 
p1.ida3masterreference)) AWTP, 

wtpartusagelink LINK, 

SELECT * FROM WTPART p1 
WHERE 
p1.latestiterationinfo = 1 AND 
p1.versionida2versioninfo = (select max(versionida2versioninfo) 
from WTPART p2 
where p2.ida3masterreference = 
p1.ida3masterreference)) CWTP 

where 
AWTP.latestiterationinfo=1 
and CWTP.latestiterationinfo=1 
and AWTM.wtpartnumber like '$pn' 
and LINK.ida3a5=AWTP.ida2a2 
and LINK.ida3b5=CWTM.ida2a2 
and LINK.ida3b5=CWTP.ida3masterreference 
and AWTM.ida2a2=AWTP.ida3masterreference"; 

=========

from 

wtpartmaster CWTM, 
wtpartmaster AWTM, 
wtpartusagelink LINK,

=====
SELECT

WTU.NAME, WFP.NAME, WTU.IDA2A2

FROM PDM7A.WFPROCESS WFP, PDM7A.WTUSER WTU

WHERE WTU.IDA2A2=WFP.IDA3B7

order by WTU.NAME