use ObjectViews
Go

SELECT TOP 200
	FO.KeyOffering
   ,FO.KeyInstn
   ,Instn.InstnName
   ,Country.CountryName
   ,FO.OfferingAnnouncementDate
   ,FO.OfferingCompletionDate
   ,FO.OfferingTerminationDate
   ,LOT.OfferingType
   ,(case FO.IPO when 1 then 'yes' else 'no' end) as IPO
   ,FO.PrivatePlacement
   ,FO.Restricted144a
   ,Fo.ShelfOffering
   ,FO.AmountOffered
FROM ObjectViews..FndgOffering_E FO
LEFT JOIN ObjectViews..Instn Instn
ON FO.KeyInstn = Instn.KeyInstn
LEFT JOIN ObjectViews..Country Country
ON Country.KeyCountry = Instn.Country
LEFT JOIN ObjectViews..LookupOfferingType LOT
ON FO.KeyOfferingType = LOT.KeyOfferingType
WHERE (FO.KeyOffering = '668286')
ORDER BY FO.UpdDate ASC