SELECT        dbo.vwPART_SITE_VIEW.ID, dbo.vwPART_SITE_VIEW.DESCRIPTION, dbo.vwPART_SITE_VIEW.STOCK_UM, dbo.vwPART_SITE_VIEW.PRODUCT_CODE, dbo.vwPART_SITE_VIEW.UNIT_MATERIAL_COST,
                         dbo.vwPART_SITE_VIEW.UNIT_PRICE, dbo.vwPART_SITE_VIEW.QTY_ON_HAND, dbo.vwPART_SITE_VIEW.QTY_ON_ORDER, dbo.vwPART_SITE_VIEW.PRIMARY_LOC_ID,
                         dbo.VENDOR.NAME AS VENDOR_NAME
FROM            dbo.vwPART_SITE_VIEW LEFT OUTER JOIN
                         dbo.VENDOR ON dbo.vwPART_SITE_VIEW.PREF_VENDOR_ID = dbo.VENDOR.ID