SELECT
  (SELECT CLIENT_NUM FROM Clients
  WHERE ID = (SELECT ClientID FROM Farms WHERE ID = FarmID)) AS CID
FROM Fields
WHERE Year = 2014 AND FIELD_NUM = '28-2'