SQL

SELECT c.Name, c.StateId, rf.*

FROM dbo.RecordingFee rf (nolock)

JOIN County c (nolock) ON c.CountyId = rf.CountyId