SELECT one.id_vodit as "ID водителя", fam as "Фамилия", voditel.name as "Имя", oth as "Отчество", date_in as "Дата отъезда", 
date_out as "Дата прибытия", moves.money + work.money + (work.money * (((sthaj/12)*10) + SUM(
	SELECT * 
	FROM work, voditel two 
	WHERE id_vodit = id_vod
        AND ID_ВНЕШН = ID_ВНУТР)))	
FROM moves, reis, voditel one, work
WHERE moves.id_move = reis.id_move
AND reis.id_reis = work.id_reis
AND id_vodit = id_vod
AND moves.id_move = 10

select one.id
from table_1 one
cross apply( -- outer apply(
  select id
  from table_2 two
  where two.id=one.id
  )
group by one.id

SELECT one.id_vodit as "ID водителя", fam as "Фамилия", !!!one!!!.name as "Имя", oth as "Отчество", date_in as "Дата отъезда", 
date_out as "Дата прибытия"
, moves.money + work.money + (work.money * (((sthaj/12)*10) + (
	SELECT count( id_work )
	FROM work c_work 
	WHERE c_work.id_vod = one.id_vodit )))	
FROM moves, reis, voditel one, work
WHERE moves.id_move = reis.id_move
AND reis.id_reis = work.id_reis
AND id_vodit = id_vod
AND moves.id_move = 10