Multiple query execution

[Ns7703]

I need to merge three reports in one application, Which displayed as worksheets in that one application. Lets call it X,Y,Z reports . In X reports I need to display all the projects with PSP _ELEMENT but in report Y I only need to display project with limited number of projects which holds some conditions like where where "PSP_ELEMENT" like '%-BZ-%' OR "PSP_ELEMENT" like '%-BZ%'. I want to ask how to write query in Data load editior in such a way that one worksheets display all the projects and another reports will display projects with some conditions

[marksouzacosta · Accepted solution]

Not sure if I understand the problem, but you can combine different data sets originated from different queries. Something like:

MyTable:
SQL SELECT * FROM TableA WHERE Z = Y .....;

Concatenate(MyTable)
SQL SELECT * FROM TableB WHERE A = ''some search' OR .....;

Concatenate(MyTable)
SQL SELECT * FROM TableC WHERE Some other condition .....;