求一条合并sql语句

Question

                                                                              
SQL> select * from OrdersORDNO                                              ORDDATE      ORDMONEY
------------------------------------------ ----------- ---------
1                                                  2009-2-15      500.00
2                                                  2009-2-16     1500.00
3                                                  2009-2-25     3000.00SQL> select * from Orderslist
     ORDNO     MERCHANDISEID                               QUANTITY
---------- --------------------------------------------
         1  a                                                 1
         2  b                                                 1
         2  c                                                 1
         3  a                                                 2
         3  b                                                 2
         3  c                                                 1
SQL> select * from Merchandises
MERCHANDISEID               MERCHANDISENAME     UNIVALENT
a                               山寨Ipo               500
b                               山寨诺鸡鸭               500
c                               山寨....              1000要求查询后  
ORDNO    ORDDATE           MeRCHANDISENAME  QUANTITY UNIVALENT
1       2009-2-15             山寨Ipo            1       500
2       2009-2-16            山寨诺鸡鸭             1       500
2       2009-2-16            山寨....             1       1000
3       2009-2-25            山寨Ipo              2       500
3       2009-2-25            山寨诺鸡鸭             2        500
3       2009-2-25            山寨....             1        1000

Answer 1

select a.ORDNO,b.ORDDATE,c.MeRCHANDISENAME,a.QUANTITY ,c.UNIVALENT 
from Orderslist a,Orders b,Merchandises c
where a.ORDNO=b.ORDNO and a.ORDNO=c.ORDNO
;

Answer 2

select ordno, ordddate, merchandisename, quantity, univalent
  from orderslist natural join orders
                  natural join merchandises;

Answer 3

更正下 ：
select a.ordno,b.orddate,c.merchandisename,a.quantity,c.univalent from orderslist a,orders b,merchandises c where a.ordno= b.ordno and a.merchandiseid = c.merchandiseid谢谢 1楼

Answer 4

感谢两位，我刚接触Order 
很多都不懂

Answer 5

直接自然联结也行吧
SELECT *
FROM ((Orderslist JOIN Orders USING(ORDNO))
   JOIN Merchandises USING(MERCHANDISEID));