SQL Vereinfachung einer Union Query wegen UniDac Problem

[hoika]

Hallo,

geht denn folgendes ?

SQL-Code:

(SELECT
  T1.ID AS Name,
  T1.Partial DIV 3600 AS Partial,
  T1.Total DIV 3600 AS Total,
  T2.Unit AS Unit
FROM Tabelle1 AS T1, Tabelle2 AS T2
WHERE T1.ID = T2.ID
  AND T2.Unit = 'hours')
UNION
(SELECT
  T3.ID AS Name,
  T3.Partial AS Partial,
  T3.Total AS Total,
  T4.Unit AS Unit
FROM Tabelle1 AS T3, Tabelle2 AS T4
WHERE T3.ID = T4.ID
  AND T4.Unit = '')
ORDER BY
  T3.ID ASC
LIMIT 10000

Heiko