Hi All,
I’ve been trying to use create a report based on the below query in WebI XI R2, but unable to succeed. Would be greatly thankful for any suggestions.
SELECT T0.C1,
T0.C2,
T0.C3,
T0.C4,
T0.C5,
DECODE(T0.C6,NULL,’’,‘Y’) AS SCHEDULED
FROM
(SELECT
DISTINCT
T3.C1,
T3.C2,
T3.C3,
T3.C4,
T1.C5,
T4.C6
FROM
(((PWSQL.V1@SCHEMA T1
INNER JOIN PWSQL.V2@SCHEMA T2
ON T1.V3 = T2.C1)
INNER JOIN PWSQL.V4@SCHEMA T3
ON T2.C1 = T3.C1 AND T2.V5 = T3.C2)
INNER JOIN PWSQL.V4@SCHEMA T7
ON T7.C3 = T3.C3 and T7.C6 = T3.C4)
LEFT OUTER JOIN PWSQL.V5@SCHEMA T4
ON (t3.C3+T3.C4) = (t4.C7+t4.C8) AND T4.C6 = ‘101’
WHERE T1.C5 NOT IN (‘A’,‘B’)
AND T3.DT IS NULL) T0
WHERE T0.C1 IN (SELECT DISTINCT T6.C1
FROM PWSQL.V5@SCHEMA T5, PWSQL.V3@SCHEMA T6,
PWSQL.V1@SCHEMA T8
WHERE T8.C5 NOT IN (‘A’,‘B’)
AND T8.V1_NB = T6.C1
AND T5.C6 = ‘101’
AND t6.C3 = t5.primary_number
AND T6.C4 = t5.secondary_number
AND T6.DT IS NULL)
ORDER BY t0.C1,
t0.C2,
t0.C3,
t0.C4
I’ve tried using subqueries to no avail.
Please do provide your valuable suggestions at the earliest.
Madhav (BOB member since 2005-04-02)