"select namefixassets.name_os as Наименование,division.name as Подразделение,os_card.number as Инвентарный,os_card_note.zavod_numb as Заводской,date_doc 
from ((((namefixassets as t1 inner join os_card on os_card.name_id=namefixassets.id)inner join os_act_move on os_act_move.os_card_id=os_card.id) 
inner join division on division.id=os_act_move.division_id) inner join os_card_note on os_card_note.os_card_id=os_card.id) 
where division.id=" + comboBox1.SelectedValue + " and os_act_move.date_doc=(select max(os_act_move.date_doc) from os_act_move t2 where t2.os_card_id=t1.os_card_id)";