Philky101
asked on
Need to add a 3rd table to this join
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
IAPRT#. IARCC9
and 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
b.CtCtr# = ' ' and
b.CtPrt# =a.ItPrt#
order by a.ItPRT#
But I need to add that we only want part# that have a reporting code that is, are not blank in this table
IAPRT#. IARCC9
and 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
b.CtCtr# = ' ' and
b.CtPrt# =a.ItPrt#
order by a.ItPRT#
Do you want to provide us some details regarding this 3rd table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.