[SELECT]
 SELECT Req.ReceiptNo,   
         Req.OrderNo,   
         Req.GoodsNo,   
         Req.MergeFlag,   
         Req.OrderQty,   
         Req.AuditQty,   
         Req.Qty,   
         Req.DestDept,   
         Req.OrderDept,   
         Req.reqdept,   
         goods.VendorNO,   
         Req.InputDept,   
         Req.Operator,   
         Req.Employee,   
         Req.ReachDate,   
         Req.InputDate,   
         Req.ReceiveDate  
    FROM Req ,goods
    where req.goodsno=goods.goodsno  

[COLUMN]
要貨單號,RECEIPTNO,char,0,0;   
錄入日期,INPUTDATE,date,0,0;  
到貨日期,REACHDATE,date,1,1;  
錄入員工,OPERATOR,char,1,0; 
經辦員工,EMPLOYEE,char,0,0;  
錄入部門,INPUTDEPT,char,0,0;
定貨部門,ORDERDEPT,char,1,0;
到貨部門,DESTDEPT,char,1,1;
要貨部門,REQDEPT,char,1,0;
廠商代碼,VENDORNO,char,1,1;
商品代碼,GOODSNO,char,0,0; 
要貨數量,ORDERQTY,dec,0,0;
審核數量,AUDITQTY,dec,0,0;
配送數量,QTY,dec,0,0;