SELECT SOURCES.SRCIDX AS "ID", 
SOURCES.NAME AS "NAME", 
SOURCES.REF AS "REF", 
SOURCES.SRCTYPE AS "TYPE",  /// PROBLEM RELATED TO THIS
DOMAINID, 
HOSTID, 
SOURCES.SRCIDX AS "SRCID" 
FROM SOURCES 
WHERE (SOURCES.ZONES=2) 
UNION 
SELECT CONFS.ID AS "ID", 
CONFS.NAME AS "NAME", 
CONFS.REF AS "REF", 
33 AS "TYPE",       /// HERE IS THE PROBLEM
0 AS "DOMAINID", 
0 AS "HOSTID", 
ID+2000 AS "SRCID" 
FROM CONFS 
WHERE (CONFS.ZONES=2)