Is it possible to gather fields from two tables in SWE? We are trying to use a UNION statement and it will not work. We want vew_cable_ex and vew_manufacturerparts_ex in the same report. Each time I apply and test, the UNION and everything after disappears.

SELECT DISTINCT

bom_manufacturer
,bom_reference
,bom_tra_0_l1
,bom_use_data0
,com_tag
,bun_tag
,com_type
,loc_text
,vcomcom_com_tag
,1 AS %ELEMENT_COUNT%

FROM

vew_manufacturerparts_ex

WHERE

bun_id = %CUR_BUNDLE_ID%
AND bom_assemblyid = -1
AND bom_objecttype != 9

ORDER BY vcomcom_com_tag ASC,com_tag ASC

UNION

SELECT DISTINCT

cab_tag

FROM

vew_cable_ex

WHERE

vew_cable_ex.cab_tag != ]][[