不行,这个我之前也试过,会提示#1060 - Duplicate column name 'id' ,我里面有id的编号
给出你自己的SQL语句以供分析。 另外建议不要贴图,直接贴文本即可。
没有图不知道效果啊。。 我的是 create view vs as select a.name,a.route,a.sequence,b.name,b.route,b.sequence from station a,station b where a.name<>b.name 会提示#1060 - Duplicate column name 'name' 如果是]create view vs as select a.*,b.* from station a,station b where a.name<>b.name 会提示#1060 - Duplicate column name 'id' 我的表就比上图的表多了一个自增的id和次序sequenc。想问怎么才能建出想上图的视图那样的视图
我查找了一下怎么让创建的视图的字段改为别的名字后弄出来了:create view sview as select a.name as name_a,a.route as route_a,a.sequence as sequence_a,b.name as name_b,b.route as route_b,b.sequence as sequence_b from station a,station b where b.name<>a.name and a.route =b.route
另外建议不要贴图,直接贴文本即可。
我的是
create view vs
as
select a.name,a.route,a.sequence,b.name,b.route,b.sequence
from station a,station b
where a.name<>b.name
会提示#1060 - Duplicate column name 'name' 如果是]create view vs
as
select a.*,b.*
from station a,station b
where a.name<>b.name
会提示#1060 - Duplicate column name 'id' 我的表就比上图的表多了一个自增的id和次序sequenc。想问怎么才能建出想上图的视图那样的视图
as
select a.name as name_a,a.route as route_a,a.sequence as sequence_a,b.name as name_b,b.route as route_b,b.sequence as sequence_b
from station a,station b
where b.name<>a.name and a.route =b.route