56,940
社区成员




create or replace view v_test as
select * from
(select 1 a1 from dual) t1,
(select 1 a2 from dual) t2,
(select 1 a3 from dual) t3,
(select 1 a4 from dual) t4
;
SELECT
`t1`.`a1` AS `a1`,
`t2`.`a2` AS `a2`,
`t3`.`a3` AS `a3`,
`t4`.`a4` AS `a4`
FROM
((((
SELECT
1 AS `a1`
) `t1`
JOIN ( SELECT 1 AS `a2` ) `t2`
)
JOIN ( SELECT 1 AS `a3` ) `t3`
)
JOIN ( SELECT 1 AS `a4` ) `t4`)