ERRATUM.

Correct query :

select b.isin, a.market, a.ccy, a.stock_mkt, max(a.year)

,max(a.month), max(a.day) from market_table a inner join

isin_table b on a.id = b.id where a.isin_closing_date=0

and a.market in ('XFFA', 'XFFF') and

b.isin_type= 'I' and b.isin = 'DEX' group by b.isin,

a.market, a.ccy, a.stock_mkt