I need to obtain the maximum value of a date, but that comparison will be made between 3 tables... I will explain better with a query...
[code] select a.last_refresh_date as d1, ae.last_refresh_date as d2, ha.last_refresh_date as d3 from tbl1 a join tbl2 ae on a.id_anuncio_externo = ae.id_anuncio_externo join tbl3 ha on a.id_anuncio_externo = ha.id_anuncio_externo [/code]
My question is how is the best way to obtain with date is the greatest, d1, d2 or d3