SQL code: SELECT A.ProductionID, A.ProductionNO, A.Title, A.Price,A.Price1, A.Unit, A.Content, O.OrderNO,O.OrderID,O.UpdateTime,O.PaymentMode, O.Memo, O.Num, O.UserID, A.Price*O.Num AS [Count],A.Price1*O.Num AS Count1,O.IsSend,O.dakuan, O.fahuo,O.SendTime,U.UserName,U.UserLevel,U.TrueName from (Production AS A INNER JOIN [Order] AS O ON A.ProductionID = O.ProductionID) INNER JOIN [User] AS U ON (U.UserID = O.UserID) WHERE A.Deleted=0
