)
B AS (
SELECT * FROM FW_STUDENT
WHERE STUDENTNAME = '张天'
)
SELECT
STUC.STUDENTNO
,B.STUDENTNAME
FROM STUC ,B
缺失 SELECT 关键字
帮忙看看了
...全文
11964打赏收藏
oracle with as 缺失 SELECT 关键字
WITH STUC AS( SELECT * FROM FW_STUDENT ) B AS ( SELECT * FROM FW_STUDENT WHERE STUDENTNAME = '张天' ) SELECT STUC.STUDENTNO ,B.STUDENTNAME FROM STUC ,B 缺失 SELECT 关键字 帮忙看看了
WITH
STUC AS(
SELECT * FROM FW_STUDENT
)
,
B AS (
SELECT * FROM FW_STUDENT
WHERE STUDENTNAME = '张天'
)
SELECT
STUC.STUDENTNO
,B.STUDENTNAME
FROM STUC ,B