每一个派生表必须有它自己的别名(Every derived table must have its own alias)

xiaoxiao2021-02-28  86

每一个派生表都必须给其取个别名

如:

select * from (select * from table_a union select * from table_b 解决办法:  select * from ( select * from table_a  union  select * from table_b ) c 如果不加上这个别名,就会出现异常

转载请注明原文地址: https://www.6miu.com/read-50863.html

最新回复(0)