请教视图的写法

[byeceg]

两张表

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联起来,做个视图.

谢谢

[WWWWA]

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

[Rotel-刘志东]

create view viewname
as
select * from a
inner join b
on a.userid=b.id;

[ACMAIN_CHM]

create view x as
select * from a inner join b on a.USERID=b.ID

[byeceg]

谢谢各位