CREATE TABLE DB2ADMIN.ATTRIBUTES (
		ID BIGINT NOT NULL ,
		ID_VAR BIGINT NOT NULL,
                ID_PROCESS BIGINT NOT NULL,
		VALUE_VAR VARCHAR(1024))

CREATE TABLE DB2ADMIN.VARIABLES (
		ID_VAR BIGINT NOT NULL ,
		NAME_VAR VARCHAR(128)

with t as (
SELECT v.name_var as q1, a.value_var as q2, a.id_process as pr
FROM DB2ADMIN.variables v
join db2admin.attributes a on (a.id_var=v.id_var)
where v.name_var='синий' 
) 
select t.q1 as NAME_VAR1, t.q2 as VALUE_VAR1,v.name_var as NAME_VAR2, a.value_var as NAME_VAR2 from t,DB2ADMIN.variables v
join db2admin.attributes a on (a.id_var=v.id_var)
where v.name_var='красный' and a.id_process=1 and t.pr=1

with t as (
SELECT v.name_var as name_var1, a.value_var as value_var1, a.id_process as pr
FROM DB2ADMIN.variables v
join db2admin.attributes a on (a.id_var=v.id_var)
where v.name_var='синий' 
) ,
 t1 as  (
SELECT t.*, v.name_var as name_var2, a.value_var as value_var2, a.id_process as pr
FROM DB2ADMIN.variables v
join db2admin.attributes a on (a.id_var=v.id_var)
where v.name_var='красный' 
)
 
select t1.*, v.name_var as NAME_VAR3, a.value_var as NAME_VAR3 from t1,DB2ADMIN.variables v
join db2admin.attributes a on (a.id_var=v.id_var)
where v.name_var='желтый' and a.id_process=1 and t.pr=1