title: How do I specify column to to select from result of join
body: <p>My table Ce_Data has a column "Fut_ID"</p>
  
  <p>Why do I get an "ambiguous" error on first line? TX."Fut_ID" does not work either</p>
  
  <pre><code>SELECT "Fut_ID"
  FROM (
  SELECT *
    FROM "Ce_Data" AS M
    JOIN (SELECT "Fut_ID", MAX("Date") AS "Most_Recent"
            FROM "Ce_Data"
           GROUP BY "Fut_ID"
         ) AS R
      ON R."Fut_ID" = M."Fut_ID" AND R."Most_Recent" = M."Date"
  ) AS TX
  </code></pre>