我和朋友正在玩
MySQL中的JOIN子句.这是我们的表结构:
create table abc
(
c1 int,
c2 char(1)
);
create table xyz
(
c2 char(1),
c3 varchar(5)
);
插入其中的值为:
insert into abc
values
(1,"a"),
(2,"b");
insert into xyz
values
("a","apple"),
("c","car");
select
*,
'full'
from abc
full join xyz
using (c2);
和
select
*,
'full'
from abc
full join xyz
on abc.c2 = xyz.c2;
从小提琴中可以看出,第一个查询返回:
| C2 | C1 | C3 | FULL |
|----|----|-------|------|
| a | 1 | apple | full |
而第二个查询引发错误:
Unknown column 'abc.c2' in 'on clause':
为什么在使用JOIN语法的ON子句时无法识别列abc.c2?