请问视图的写法

请教视图的写法
两张表

SQL code

TableAField             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

查看更多 下一篇