Forum Discussion
pulled datasets from CTEs but got stuck with joining them together
Hi - Thanks for your time, I would like to give the scenario clearly and kindly request for some ideas on the best route.. I am using CTEs to pull data ... say for example data that belongs to Paren...
We don't have your database to test anything.
lease post table design as DDL, some sample data as DML statement and the expected result.
lease post table design as DDL, some sample data as DML statement and the expected result.
Hi olafhelper, please see if this helps
CREATE TABLE Incident_Parent (
GroupID varchar(10),
GroupName varchar(25),
IncidentID varchar(10),
CustomerImpacted varchar(50)
);
INSERT INTO Incident_Parent values ('G123', 'GlobalSupport', 'INC123', 'Customer111' )
INSERT INTO Incident_Parent VALUES ('G123','GlobalSupport','INC123','Customer222')
INSERT INTO Incident_Parent VALUES ('G345','North America','INC345','Customer333')
INSERT INTO Incident_Parent VALUES ('G345','North America','INC345','Customer444')
CREATE TABLE Incident_Child (
IncidentID varchar(10),
Incident_Task_ID varchar(15),
Incident_Task_Name varchar(25)
);
INSERT INTO Incident_Child values ('INC123','ITASK1','TaskName1')
INSERT INTO Incident_Child values('INC123','ITASK2','TaskName2')
INSERT INTO Incident_Child values('INC123','ITASK3','TaskName3')
INSERT INTO Incident_Child values('INC123','ITASK4','TaskName4')
INSERT INTO Incident_Child values('INC123','ITASK5','TaskName5')
INSERT INTO Incident_Child values('INC345','ITASK888','TaskName888')
INSERT INTO Incident_Child values('INC345','ITASK999','TaskName999')
INSERT INTO Incident_Child values('INC345','ITASK111','TaskName111')
CREATE TABLE Incident_Parent (
GroupID varchar(10),
GroupName varchar(25),
IncidentID varchar(10),
CustomerImpacted varchar(50)
);
INSERT INTO Incident_Parent values ('G123', 'GlobalSupport', 'INC123', 'Customer111' )
INSERT INTO Incident_Parent VALUES ('G123','GlobalSupport','INC123','Customer222')
INSERT INTO Incident_Parent VALUES ('G345','North America','INC345','Customer333')
INSERT INTO Incident_Parent VALUES ('G345','North America','INC345','Customer444')
CREATE TABLE Incident_Child (
IncidentID varchar(10),
Incident_Task_ID varchar(15),
Incident_Task_Name varchar(25)
);
INSERT INTO Incident_Child values ('INC123','ITASK1','TaskName1')
INSERT INTO Incident_Child values('INC123','ITASK2','TaskName2')
INSERT INTO Incident_Child values('INC123','ITASK3','TaskName3')
INSERT INTO Incident_Child values('INC123','ITASK4','TaskName4')
INSERT INTO Incident_Child values('INC123','ITASK5','TaskName5')
INSERT INTO Incident_Child values('INC345','ITASK888','TaskName888')
INSERT INTO Incident_Child values('INC345','ITASK999','TaskName999')
INSERT INTO Incident_Child values('INC345','ITASK111','TaskName111')