geethkal12
Technical User
Hello All,
I need to create a report using UNION relationship object.
Please suggest me the procedure of using UNION in cognos report studiousing the below DB2 query..
select "NM" from "DTTSKC01"."TTS_FREIGHT_FORWARDER_REF"
where "NM" IN(Select distinct "CLMN_NM" from "DTTSKC01"."TTS_BUS_DETAILS))
UNION
(Select "NM"
from "DTTSKC01"."TTS_FREIGHT_FORWARDER_REF"
where "NM" IN(Select Distinct "TRADING_NM" from "DTTSKC01"."TTS_BUS_DETAILS")).
thanks a lot
Geetha
I need to create a report using UNION relationship object.
Please suggest me the procedure of using UNION in cognos report studiousing the below DB2 query..
select "NM" from "DTTSKC01"."TTS_FREIGHT_FORWARDER_REF"
where "NM" IN(Select distinct "CLMN_NM" from "DTTSKC01"."TTS_BUS_DETAILS))
UNION
(Select "NM"
from "DTTSKC01"."TTS_FREIGHT_FORWARDER_REF"
where "NM" IN(Select Distinct "TRADING_NM" from "DTTSKC01"."TTS_BUS_DETAILS")).
thanks a lot
Geetha