Можно ли с помощью Select Query реализовать такой запрос (интересует вложенность запросов):
SELECT "tbl_Contact"."Name" PersonalName, "tbl_CallType"."Name" TypeName, "tbl_CallResult"."Name" ResultName, "tbl_Contact"."DepartmentID", a.*
FROM (
SELECT "tbl_Call"."CreatedByID", "DirectionID", "TypeID", "ResultID", COUNT(*) Quantity, MIN("TalkTime"), MAX("TalkTime"), AVG("TalkTime")
FROM "tbl_Call"
WHERE 1 = 1
AND Trunc("tbl_Call"."CreatedOn") >= :fromdate
AND Trunc("tbl_Call"."CreatedOn") = :todate
AND nvl2(nullif("DirectionID",'0'),0,nvl2("ConnectionDate",0,1)) > 1
GROUP BY "tbl_Call"."CreatedByID", "DirectionID", "TypeID", "ResultID"
UNION ALL
SELECT "tbl_Call"."CreatedByID", '2' "DirectionID", "TypeID", "ResultID", COUNT(*) Quantity, MIN("TalkTime"), MAX("TalkTime"), AVG("TalkTime")
FROM "tbl_Call"
WHERE 1 = 1
AND Trunc("tbl_Call"."CreatedOn") >= :fromdate
AND Trunc("tbl_Call"."CreatedOn") = :todate
AND nvl2(nullif("DirectionID",'0'),0,nvl2("ConnectionDate",0,1)) = 1
GROUP BY "tbl_Call"."CreatedByID", "DirectionID", "TypeID", "ResultID"
) a, "tbl_Contact", "tbl_CallResult", "tbl_CallType"
WHERE 1 = 1
AND a."CreatedByID" = "tbl_Contact"."ID"
AND a."ResultID" = "tbl_CallResult"."ID" (+)
AND a."TypeID" = "tbl_CallType"."ID" (+)
ORDER BY "tbl_Contact"."Name", "DirectionID", "tbl_CallType"."Name", "tbl_CallResult"."Name"