Question

求MySql高手，帮我写一条语句，谢谢。我要看表里每列的值怎么写啊？

表1：SAOSHIP 字段：shipdate,qty,shpqty,orderno
表2：SAOMSTR 字段：custporef,orderno
表3：MRJMATR 字段：orderno,MatrCode,style,Issqty,qtyunit
表4：PUOITEM 字段：matrCode,Description

Answer 1

SELECT * FROM SAOSHIP,SAOMSTR,MRJMATR,PUOITEM
WHERE SAOSHIP.orderno = SAOMSTR.orderno
AND SAOMSTR.orderno = MRJMATR.orderno
AND MRJMATR.MatrCode = PUOITEM.matrCode

Answer 2

select * from SAOSHIP;
select * from SAOMSTR ;
select * from MRJMATR ;
select * from PUOITEM ;
这样？还是下面的
select a.*,b.*,c.*,d.*
from SAOSHIP a, SAOMSTR b, MRJMATR c, PUOITEM d
where a.orderno=b.orderno and a.orderno=c.orderno and c.MatrCode=d.MatrCode

Answer 3

select * from 表名

Answer 4

同上