两个视图之间的SQL连接 [英] SQL join between two views

问题描述

是否可以连接两个视图并在表和视图之间进行连接。如果可能的话请给我一些例子。感谢谁回复并花了他们宝贵的时间。

Is it possible join two views and join between tables and views. If possible please show me some example. Thanks who response and spent their valuable time.

推荐答案

你好b $ b

是的你可以从sql server加入视图和表格任何其他DBMS，例如来自sql server请转到views节点并创建新视图并在此处添加表和视图;）



获取有关它的更多信息请点击此链接：

http://msdn.microsoft.com/ en-us / library / a1kaf2x2.aspx [ ^ ]

http://www.ehow.com /video_4982926_creating-view-sql-server.html [ ^ ]



在此链接中，您可以使用可视化数据库工具找到该怎么做：

http://msdn.microsoft.com/en-us/library/ms189269 （v = sql.90）.aspx [ ^ ]



如果你想用SQL命令做，请转到以下链接：

http://www.w3schools.com/sql/sql_view.asp [ ^ ]

http://msdn.microsoft.com/en-us/library/ms187956.aspx [ ^ ]

http://www.sql-server-performance.com/2004/views-in-sql-server/ [ ^ ]



最好的问候。

Hi
Yes you can join view and table from sql server or any other DBMS for example from sql server please go to the views node and create new view and add your tables and views here ;)

for get the more information about it please follow of this link:
http://msdn.microsoft.com/en-us/library/a1kaf2x2.aspx[^]
http://www.ehow.com/video_4982926_creating-view-sql-server.html[^]

and at this link you can find how to do, with visual database tool:
http://msdn.microsoft.com/en-us/library/ms189269(v=sql.90).aspx[^]

If you want do it with SQL commands go to the these links:
http://www.w3schools.com/sql/sql_view.asp[^]
http://msdn.microsoft.com/en-us/library/ms187956.aspx[^]
http://www.sql-server-performance.com/2004/views-in-sql-server/[^]

Best Regards.

这篇关于两个视图之间的SQL连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！