17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM (
SELECT B.VALUE
FROM (
SELECT *
FROM (
WITH
TAB1 AS
(SELECT 'A' ID,'DKJSALK' NAME FROM DUAL UNION ALL
SELECT 'B' ID,'TERSDSK' NAME FROM DUAL UNION ALL
SELECT 'C' ID,'ERSDSDS' NAME FROM DUAL),
TAB2 AS
(SELECT 'A' ID,2322 VALUE FROM DUAL UNION ALL
SELECT 'A' ID,8980 VALUE FROM DUAL)
SELECT TAB2.*,
TAB1.NAME
FROM TAB1,TAB2
WHERE TAB1.ID = TAB2.ID)
) B
) C
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select (select (select ID from city_code a where a.id=b.city_id ) from rep_
statusmsg b where b.city_id=c.id)
2 from city_code c ;
(SELECT(SELECTIDFROMCITY_CODEAWHEREA.ID=B.CITY_ID)FROMREP_STATUSMSGBWHEREB.CITY_
--------------------------------------------------------------------------------
1
2
3
SQL>