Partners

IU Manufacturers

SELECT [CompanyName] as co_name ,[Address1] as addr1 ,[Address2] as addr2 ,[City] ,[StateAndProvinceName] as state ,co.CountryName as country FROM [drm_indianauniv].[dbo].[ContrCompanyXRef] clxr INNER JOIN [drm_indianauniv].[dbo].[Companies] c on c.CompanyID=clxr.CompanyID LEFT JOIN StateAndProvinces sap on sap.StateAndProvinceID=c.StateID LEFT JOIN Countries co on co.CountryId=c.CountryID where StatusID=301 and clxr.ContrID= and ((clxr.AsBusinessType=2) or (clxr.AsBusinessType=4))

Licensee's Manufacturers


#encodeForHTML(rs.co_name)#

#encodeForHTML(rs.addr1)#
#encodeForHTML(rs.addr2)#
#encodeForHTML(rs.city)#
#encodeForHTML(rs.state)#
#encodeForHTML(rs.Country)#

Sorry, an error has occurred, please try again.