一对多关系查询
表:
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
使用t-sql语句将sqlserver2k数据导入paradox的功能我已实现，用的是insert into ... from table in [ODBC][ODBC;Driver=SQL Server...]的办法，当我准备如法炮制完成paradox导入oracle时却不行，不报错但是执行后没� ......
