SELECT t1.changedon as [Changed On], t1.fldname as [Field Name],
CASE WHEN (t1.Fldname='LastKnownProvider' and t1.oldValue > 1000) THEN coalesce((t4.ProviderName + ' (' + t4.ProviderAddress + ', ' + t4.ProviderCity + ')'),cast(t1.oldvalue as varchar))  ELSE coalesce(t2.label,cast(t1.oldvalue as varchar)) END as [Old Value],
CASE WHEN (t1.Fldname='LastKnownProvider' and t1.newValue > 1000) THEN coalesce((t5.ProviderName + ' (' + t5.ProviderAddress + ', ' + t5.ProviderCity + ')'),cast(t1.Newvalue as varchar))  ELSE coalesce(t3.label, cast(t1.NewValue as varchar)) END as [New Value]
CASE WHEN t1.Changedfrom ='Upload' THEN 'UPLOAD' ELSE 'manual' END AS [Upload/Manual]
FROM tblFieldChanges t1
LEFT JOIN tblReferenceData t2 on t1.oldvalue=cast(t2.id as varchar)
LEFT JOIN tblReferenceData t3 on t1.newValue=cast(t3.id as varchar)
left join tblProviders t4 on t1.oldvalue = cast(t4.ProviderID as varchar)
left join tblProviders t5 on t1.NewValue = cast(t5.ProviderID as varchar)
WHERE TblName = 'tblClients' AND PKID = 8558

ID    tblName    FldName    PKID    Oldvalue   NewValue   ChangedOn
17    tblClients Cost       19      1774.14    1775.19    7/21/2017 8:45am