Database

SELECT SUM(t1.value1 - t2sum) 
FROM table1 t1 
INNER JOIN 
  ( SELECT parent, SUM( value2 ) as t2sum
    FROM t2
    GROUP BY parent ) t2
ON
  t2.parent = t1.id
WHERE
  t1.prop = 0 AND
  t1.payed = 0 AND
  t1.date = '20060321'

SELECT a.* 
FROM Voyage_End a, Voyage_End b 
WHERE a.Voyage_ID != b.Voyage_ID AND a.platenumber = b.platenumber AND a.startdate = b.startdate

SELECT (SELECT TOP 1 voyage_id 
        FROM Voyage_End a where a.platenumber = b.platenumber and a.startdate = b.startdate) as voyage_id, PlateNumber,StartDate 
FROM Voyage_End b GROUP BY platenumber, startdate

insert into voyage_end2 (platenumber, startdate) select distinct platenumber, startdate from Voyage_End

insert into voyage_end2 (voyage_id,platenumber, startdate,Driver1,Driver2)
SELECT (SELECT TOP 1 voyage_id 
        FROM Voyage_End a where a.platenumber = b.platenumber and a.startdate = b.startdate) as voyage_id, 
PlateNumber,StartDate, 
(SELECT TOP 1 Driver1 
        FROM Voyage_End a where a.platenumber = b.platenumber and a.startdate = b.startdate order by Driver1) as Driver1, 
(SELECT TOP 1 Driver1 
        FROM Voyage_End a where a.platenumber = b.platenumber and a.startdate = b.startdate and 
	(SELECT TOP 1 Driver1 FROM Voyage_End a where a.platenumber = b.platenumber and a.startdate = b.startdate order by Driver1)  != Driver1 order by Driver1 desc) as Driver2
FROM Voyage_End b
 GROUP BY platenumber, startdate