could someone of you guide me to combine the following SQL into the master SQL?
SQL to combine in the below master SQL (big one)
select x.policyinstanceid , x.customerID, y.value as client_segment from
(select f.identifier as policyinstanceid , f.customerID
from session.incomm a left join qis.rppolicyinstance f
on a.policyinstanceid=f.identifier) as x left join qis.rpcustomerfield y
on x.customerid=y.customerid where y.externalidentifier='customerSubsegmentGE'
proc sql noprint;
connect to &glb_db2.(datasrc=&glb_db2_src. Authdomain=DB2AuthODS connection=global);
create table incomm2 as
select * from connection to db2(
with temp1 as (select y.ExternalIdentifier as commnr,
y.communicationtypeid,
y.communicationdescriptionid,
y.inboxforcommunicationID,
y.isincoming as incoming,
y.policyid,
y.policyinstanceid,
y.tscommunicationcreated,
y.datetobecompleted,
y.createdbylogonuserid,
z.externalidentifier as polisnr
from qis.rpcommunication y, qis.rppolicy z
where y.policyid=z.identifier)
select b.name as documenttype, b.identifier as communicationdescriptionid,c.identifier as communicationtypeid ,c.externalidentifier,c.Name as commtype,
e.identifier as createdbylogonuserid,
e.externalidentifier as creator_duser,
e.lastname,e.firstname
from temp1 as a
left join qis.rpcommunicationdescription as b
on a.communicationdescriptionid=b.identifier
left join qis.rpcommunicationtype as c
on a.communicationtypeid=c.identifier
left join
(select distinct identifier as inboxforcommunicationid,name as afdeling from qis.rpinboxforcommunication where identifier in ('00000000001','10000000000','10000000001','10000000003')) as d
on a.inboxforcommunicationID=d.inboxforcommunicationid
left join qis.rplogonuser as e
on a.createdbylogonuserid=e.identifier
);
disconnect from db2;
quit;
Master SQL:
