The following code works fine.But I need to add that we only want part# that have a reporting code that is, are not blank in this table "Audia"IAPRT# would join on the other prt# and then we want this col added to the output: IARCC9and then we need to sort by that as well.

select ItQty#,IhDocd,ItPRT# from pklib.Fileout1 a join astdta.icEct1 b on b.CtCom#= a.ItCom# and

Ok thanks holy man, i need one thing. "ad.IARCC9 from astdta.audia " this line i added but it does not compile. I need the field from the last table into the output. * i added its not working. i need that col in the output. it's all based on that col. which is the customer name.

select ItQty#,IhDocd,ItPRT# from pklib.Fileout1 a ad.IARCC9 from astdta.audia * join astdta.icEct1 b on