请问视图的写法

请教视图的写法

两张表

SQL code

  

TableA
Field             Type           Null    Key      Extra                
USERID            int(11)        NO      PRI      auto_increment    
LOGINNAME         varchar(50)    NO                                           
NICKNAME          varchar(50)    YES                                    
USERNAME          varchar(50)    YES                                 
PASSWORD          varchar(50)    NO   
                                   
TableB 
Field             Type           Null    Key      Extra                
ID                int(11)        YES     MUL          
homePage          varchar(50)    YES                                          
birthday          varchar(50)    YES                                    
province          varchar(50)    YES                                 
city              varchar(50)    YES   

TableA用户基本信息表,TableB用户扩充信息表 2个表通过id关联.

现在想把2联起来,做个视图.

谢谢

select * from a inner join b on a.USERID=b.id




create view viewname

as

select * from a 

inner join b 

on a.userid=b.id;

create view x as 

select * from a inner join b on a.USERID=b.ID