SELECT c1,
(SELECT 1 FROM dual) c2
FROM table1;
可以运行那么怎么写才能运行
SELECT c1,
(SELECT 1,2 FROM dual) (c2,c3)
FROM table1;这个不要
SELECT c1,
(SELECT 1 FROM dual) c2,
(SELECT 2 FROM dual) c3
FROM table1;
(SELECT 1 FROM dual) c2
FROM table1;
可以运行那么怎么写才能运行
SELECT c1,
(SELECT 1,2 FROM dual) (c2,c3)
FROM table1;这个不要
SELECT c1,
(SELECT 1 FROM dual) c2,
(SELECT 2 FROM dual) c3
FROM table1;
table1,(select 1 c2,2 c3 from dual)
改这个我才能明白:
SELECT c1,
(SELECT c2,c3 FROM table2 where c1 = table1.c1) (c2,c3)
FROM table1;
select c1,a.c2,a.c3 from
table1,(select 1 c2,2 c3 from dual)a
就行了你那么写不行,这是语法问题
SELECT c1,
(SELECT c2,c3 FROM table2 where c1 = table1.c1) (c2,c3)
FROM table1; 这是我改的,还有没有别的?
SELECT c1,
(SELECT c2 FROM table2 where c1 = table1.c1) c2,
(SELECT c3 FROM table2 where c1 = table1.c1) c3
FROM table1;
SELECT c1,
(SELECT c2, c3 FROM table2 WHERE c1 = table1.c1)(c2, c3),
(SELECT MAX(c4) FROM table4 WHERE c1 = table1.c1) c4,
(SELECT c5 FROM table5 WHERE c1 = table1.c1 AND ROWNUM = 1) c5
FROM table1;