Hi,
I had create a view with union operation.
The view have static field, exm:
create view v_aaa as
select 0 code, f1, ... from t1... where ...
union all
select 50 code, f1, ... from t2... where ...
Ok!
In Crystal Report 8.5:
select code, f1 from v_aaa odrder by f1
So, CR don't fetch...