MapReduce服务 MRS-JOINS:Qualifying Column Names

时间:2023-11-01 16:25:24

Qualifying Column Names

当JOIN的两个relation有相同的列名时,列引用必须使用relation别名(如果relation有别名)或relation名称进行限定:

SELECT nation.name, region.name FROM nation CROSS JOIN region;SELECT n.name, r.name FROM nation AS n CROSS JOIN region AS r;SELECT n.name, r.name FROM nation n CROSS JOIN region r;
support.huaweicloud.com/cmpntguide-lts-mrs/mrs_01_249075.html