SQL Vereinfachung einer Union Query wegen UniDac Problem

[omata]

Warum so kompliziert?

SQL-Code:

SELECT t1.id AS name,
       CASE WHEN t2.unit = 'hours' 
         THEN t1.partial DIV 3600 
         ELSE t1.partial 
       END AS partial,
       CASE WHEN t2.unit = 'hours' 
         THEN t1.total DIV 3600 
         ELSE t1.total
       END AS total,
       t2.unit AS unit
FROM tabelle1 t1
INNER JOIN tabelle2 t2
  ON t1.id = t2.id
ORDER BY name LIMIT 10000