Create and Alter View

http://www.w3schools.com/sql/sql_view.asp

SQL CREATE VIEW Syntax

 

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Create(Alter) view Testestst1

 

 

 

as

SELECT Test1.Id, Test2.Id As IDD

 

 

from Test1

 

 

inner join Test2 on Test1.Id = Test2.Id where Test1.Id = 1 and Test2.Name = '11'

转载于:https://www.cnblogs.com/Jessy/archive/2011/09/14/2176425.html