Workaround for Creating Views with UNION
Posted in 1998
Margarita Cruz — — source: Informix-list mailing list archive (1991-1998)
I need to implement the following SELECT statement as a view, however, IDS =
7.23 does
not allow unions on views. (IDS 7.3 does):
SELECT 1, 0,
maintent.mtnoi, sparepart.spptoi
FROM mc.maintent,
mc.sparepart
WHERE maintent.splst_oi =3D sparepart.splst_oi
AND maintent.splst_oi IS NOT NULL
AND sparepart.ppl_oi IS NULL
UNION ALL
SELECT 2, 0,
maintent.mtnoi, sparepart_1.spptoi
FROM mc.maintent,
mc.sparepart,
mc.sparepart sparepart_1
WHERE maintent.splst_oi =3D sparepart.splst_oi
AND sparepart.ppl_oi =3D sparepart_1.splst_oi
AND maintent.splst_oi IS NOT NULL
AND sparepart.ppl_oi IS NOT NULL
AND sparepart_1.ppl_oi IS NULL; =
Thanks.