数据库 视图建立

1:关联查询,建立在表关系之上

例如:

SELECT m.*,n.realname as realname FROM dbo.tbl_ask m,dbo.tbl_member n where m.userid=n.id

2：几张没关系的表输入进行融合到一张视图里面

例如:

SELECT id,pic,addtime,title,short,clicks,type FROM dbo.tbl_mag_news WHERE publish=1
UNION 
SELECT id,pic,addtime,titles,short,clicks,type FROM dbo.tbl_news WHERE publish =1
UNION 
SELECT id,pic,addtime,titles,short,clicks,type FROM dbo.tbl_continuing WHERE publish =1
UNION 
SELECT id,pic,addtime,titles,short,clicks,type FROM dbo.tbl_train WHERE publish =1
UNION 
SELECT id,pic,addtime,titles,short,clicks,type FROM dbo.tbl_development WHERE publish =1

注意：

所以注意字段类型....

还有一个就是其中字段有不一样的如：title  titls

最后得到的数据字段名会以前字段命名者为准,则声称的是title而不是titles