select A.ordertime,A.OrderNum,A.ProdId,A.BuyPrice,A.ProdUnit,A.PEI,A.FEI,B.memo,B.thiskou,B.Paytype,B.Notes,C.ProdName,D.StatusDefine from buyok_Order A,buyok_OrderList B,buyok_produc C,Order_type D where A.OrderNum ='' and A.OrderNum = B.OrderNum and A.ProdId=C.Prodid and B.Status = D.Status