求助一下高手们，这样的视图怎么建立呢。

Question

表a(用户表)
--------------------
userid   username
1                wlm
2                lisi
-------------------------
表b(商品表)
---------------------------
spid        spname
1                 面包
2                 饼干
3                 巧克力
--------------------------------
表c(订单表)
-------------------------
ddid         ddtime        ddmoney     useridfk    spidfk
1               2014.1.1    10                      1              1
2               2014.1.1    15                      1              2
3               2014.4.3     50                      2             1
------------------------------------------怎么建立个视图弄成下面这样
ddid          ddtime         ddmoney        useridfk   spidfk        username       spname
1                2014.1.1         10                       1            1                     wlm                 面包
2                2014.1.1         15                       1             2                    wlm                 饼干
3                2014.4.3          50                      2             1                     lisi                  面包
------------------------------------------------------求助一下高手，我是新手，实在搞不来。帮帮我吧。谢谢你们了。

Answer 1

create view viewName as 
select c.ddid,c.ddtime.c.ddmoney,c.useridfk,c.spidfk,a.username,b.spname 
from c,a,b where c.useridfk = a.userid and c.spidfk = b.spid

Answer 2

SELECT * FROM C INNER JOIN B ON C.spidfk=B.spid
INNER JOIN A ON C.useridfk=A.userid

Answer 3

create view view_name
as
select * from c inner join b 
on c.spidfk=b.spid
inner join on c.useridfk=a.userid;

Answer 4

select o.ddid,o.ddtime,o.ddmoney,o.useridfk,o.spidfk,u.username,p.spname
from 订单表 o,商品表 p,用户表 u
where o.useridfk=u.userid
and o.spidfk=p.spid