Oracle 9i Ò»¶Ô¶àµÄ¹Øϵ²éѯ

Ò»¶Ô¶à¹Øϵ²éѯ

±í:
ea,eb,ga,gb
±í¹ØϵÈçÏÂ
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33


ÊÂÀýÊý¾Ý¼°¹ØϵÈçÏÂ:
SQL code:

SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (SELECT 'G1' gb1, '1' gb3, 'E1' gb31, '1' gb33
from dual
UNION ALL
SELECT 'G1', '2', 'E1', '2'
from dual
UNION ALL
SELECT 'G2', '3', 'E2', '3'
from dual
UNION ALL
SELECT 'G1', '4', 'E1', '3'
from dual
UNION ALL
SELECT 'G2', '4', 'E1', '3'
from dual
UNION ALL
SELECT 'G2', '6', 'E2', '6'
from dual
UNION ALL
SELECT 'G3', '7', 'E2', '7'
from dual
UNION ALL
SELECT 'G4', '8', 'E2', '8' from dual) gb,
(SELECT 'G1' ga1
from dual
UNION ALL
SELECT 'G2'
from dual
UNION ALL
SELECT 'G3' from dual) ga,
(SELECT 'E1' eb1, '1' eb3
from dual
UNION ALL
SELECT 'E1', '2'
from dual
UNION ALL
SELECT 'E1', '3'
from dual
UNION ALL
SELECT 'E1', '4'
from dual
UNION ALL
SELECT 'E1', '5' from dual) eb,
(SELECT 'E1' ea1 from dual) ea
WHERE ea1 = eb1
AND ga1