>>> SELECT
>>> x1,
>>> x2,
>>
>> X.x3
>> FROM ... ,
>>
>>
>>> ( SELECT ... FROM ... WHERE ...
>>> UNION
>>> SELECT ... FROM ... WHERE ...) as X.x3
WHERE Y.a = X.a
I fail to see the problem...
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab