各视图或函数中的列名必须唯一?????

Question

create view select_newsasselectAMUSEMENT.news_id,AMUSEMENT.news_title,AMUSEMENT.news_content,AMUSEMENT.news_time,AMUSEMENT.news_coming,AMUSEMENT.news_author,FINANCE.news_id,FINANCE.news_title,FINANCE.news_content,FINANCE.news_time,FINANCE.news_coming,FINANCE.news_author,GAME.news_id,GAME.news_title,GAME.news_content,GAME.news_time,GAME.news_coming,GAME.news_author,HEALTHY.news_id,HEALTHY.news_title,HEALTHY.news_content,HEALTHY.news_time,HEALTHY.news_coming,HEALTHY.news_author,MILITARY.news_id,MILITARY.news_title,MILITARY.news_content,MILITARY.news_time,MILITARY.news_coming,MILITARY.news_author,SPORTS_NEWS.news_id,SPORTS_NEWS.news_title,SPORTS_NEWS.news_content,SPORTS_NEWS.news_time,SPORTS_NEWS.news_coming,SPORTS_NEWS.news_authorfrom AMUSEMENT,FINANCE,GAME,HEALTHY,MILITARY,SPORTS_NEWS
我的视图麻烦了点，不过问题出在哪啊？
总提示我：各视图或函数中的列名必须唯一。多次指定了列名 'news_id'（属于视图或函数 'select_newss'）。

Answer 1

给他们取个别名例如select AMUSEMENT.news_id as a_news_id,MILITARY.news_id as m_news_di

Answer 2

CREATE view select_newsASSELECTa.news_id a_id,a.news_title a_title,a.news_content a_content,
a.news_time a_time,a.news_coming a_coming,a.news_author a_author,f.news_id f_id,f.news_title f_title,f.news_content f_content,
f.news_time f_time,f.news_coming f_coming,f.news_author f_author,#还有三个就省略了。。FROM AMUSEMENT a,FINANCE,GAME f,HEALTHY h,MILITARY m,SPORTS_NEWS s 

Answer 3

create view v_stu_c
as 
select '学号，姓名，课程编号'
from curriculum ,student_info服务器: 消息 4511，级别 16，状态 1，过程 v_stu_c，行 3
创建视图或函数失败，因为没有为第 1 列指定列名。
请问：我的是什么问题呢
谢谢