Re: Query for unkown column name

[Rick James]

select  p.name,
        p.currency,
        x.rate
    FROM  player AS p
    JOIN  exchangerate x ON x.currency = p.currency
    WHERE  p.id = 1
      AND  x.date = CURRENT_DATE();