selecting records where max value

[La Rocca Network, Inc.]

Hi !

is there any way to do this ?

SELECT T2.monedaID, T2.fecha, T1.descripcion, T2.compra, T2.venta FROM UYMonedasBCU 
T1, UYMonedasCotizaInter T2 
WHERE 
(T2.fecha = (SELECT DISTINCT MAX (T3.fecha )FROM 
uymonedascotizainter T3 )) AND (T1.forma = 'Billete') AND (T2.monedaID = T1.id )

The matter is that I would like to select the set of records which values where 
inserted recently among a lot of records inserted in different dates...

That works with our current SQL server but doesn't with mySQL.

Any help ?

Regards,
Nelson