SELECT * FROM
obroty_dokumentow obrdokx
inner join (Select obrdok.id_materialu, max(obrdok.rekord_hurtu) as max_rekord  from obroty_dokumentow obrdok group by obrdok.id_materialu) YY on
    obrdokx.id_obrotu = yy.id_obrotu
    and obrdokx.rekord_hurtu = yy.rekord_hurtu
    and obrdokx.data_obrotu = '2.11.2006'