SELECT table1.ID, table1.name ,table1.KOLVO, table1.PRICE,
       table2.marka, table2.znachenie, table1.date
FROM TABLE1, TABLE2
  WHERE TABLE1.NAME='M1' AND TABLE1.DATE=TABLE2.DATE
union all
SELECT table1.ID, table1.name ,table1.KOLVO, table1.PRICE,
       null as marka, null as znachenie, null as date
FROM TABLE1 
  WHERE TABLE1.NAME<>'M1' 
  order by table1.ID

with
  xT1 as 
    (
      select t.*, row_number() over(order by id) as rn from table1 t
    )
, xT2 as 
    (
      select t.*, row_number() over(order by id) as rn from table2 t
    )
select *
 from xT1
 left join xT2
   on xT1.rn/4 + 1 = xT2.rn
  and xT1.rn%4 = 1

select table1.ID, table1.name ,table1.KOLVO, table1.PRICE,
       table2.marka, table2.znachenie, table2.date
 from table1 
 left join table2
   on table1.date = table2.date
  and table1.name= 'M1'