1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
|
SELECT
V_TA1.col1
,V_TA1.col2
,TB.col7
,TB.col8
,V_TA1.col4
,V_TA1.col9
,V_TA1.col10
FROM TB
LEFT OUTER JOIN (
SELECT
TA.col1
,TA.col2
,TA.col3
,TA.col4
,TC.col9
,TD.col10
FROM TA
INNER JOIN TC ON TC.col9 = TA.col9
INNER JOIN TD ON TD.col10 = TA.col10
WHERE TA.col4 = 4
) V_TA1
ON V_TA1.col1 = TB.col5
AND V_TA1.col2 = TB.col6
AND V_TA1.col3 = TB.col7
WHERE EXISTS (SELECT 1
FROM (
SELECT
TA.col1
,TA.col2
,TA.col3
,TA.col4
,TC.col9
,TD.col10
FROM TA
INNER JOIN TC ON TC.col9 = TA.col9
INNER JOIN TD ON TD.col10 = TA.col10
WHERE TA.col4 = 4
) V_TA2
WHERE
V_TA2.col1 = TB.col5
AND V_TA2.col2 = TB.col6) |
Partager