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'