Thanks Maeltar,

I am nt sure how to incorp your code into my script. Here is my script. Your help is TRULY appreciated.

SELECT
dbo.ITEM.ITEM_NO
,dbo.ITEM.DESCR
,dbo.ITEM.CTLG_NO
,dbo.ITEM.COMDTY_CD
,dbo.ITEM.STAT
,dbo.ITEM_VEND.ORDER_UM_CD
,dbo.ITEM_VEND.CORP_ID
,dbo.ITEM_VEND.CONTRACT_ID
,dbo.ITEM_VEND_PKG.PRICE
,dbo.MFR.NAME


FROM dbo.ITEM INNER JOIN
dbo.ITEM_VEND ON dbo.ITEM.ITEM_ID = dbo.ITEM_VEND.ITEM_ID AND dbo.ITEM.ITEM_IDB = dbo.ITEM_VEND.ITEM_IDB INNER JOIN
dbo.ITEM_VEND_PKG ON dbo.ITEM_VEND.ITEM_VEND_ID = dbo.ITEM_VEND_PKG.ITEM_VEND_ID AND
dbo.ITEM_VEND.ITEM_VEND_IDB = dbo.ITEM_VEND_PKG.ITEM_VEND_IDB INNER JOIN
dbo.MFR ON dbo.ITEM.MFR_ID = dbo.MFR.MFR_ID AND dbo.ITEM.MFR_IDB = dbo.MFR.MFR_IDB

WHERE ITEM.STAT=1