Direct DB Request- Connect to2 schemas using 2 connections pools at a time?
645922Aug 14 2009 — edited Aug 17 2009
Will “Direct Database Request” feature helps to connect to two connection pools at a time?
Report output is based on UNION of two select statements coming from two schemas, two connection pools are created to connect to two Schemas
First select statement is coming from one schema and second select statement is coming form the other
Select column1, column2, column3 from A, B, C
Select column4, column5, column6 from X, Y, Z
A, B, C tables are coming from first schema and X, Y, Z are coming from the other
How to get the above out put using “Direct Database Request” feature