Hi Forum;

This one works for the 3 engines:

select * from
(select "TPRO"."DSCR" as "D_TPRO",cast(' ' as character(1)) as "NUME"
from "PROC" left outer join "TPRO" on "PROC"."TPRO"="TPRO"."TPRO"
where "PROC"."PROC"='1KZM64V704'
union
select "TPRO"."DSCR" as "D_TPRO", "OTIP"."NUME" from "OTIP" left outer
join "TPRO" on "OTIP"."TPRO"="TPRO"."TPRO"
where "OTIP"."PROC"='1KZM64V704') as X
order by "NUME"

Thank you!

Dany