SELECT A.ID AS AID , A.客户名称 AS A客户名称, A.订单号 AS A订单号, A.订单日期 AS A订单日期, A.操作人 AS A操作人, A.状态 AS A状态, A.可删标记 AS A可删标记, A.操作日期 AS A操作日期 FROM 销售订单 AS A order by A.ID limit 0,20 销售订单
SELECT A.ID AS AID , A.操作人 AS A操作人, A.收入分类 AS A收入分类, A.状态 AS A状态, A.可删标记 AS A可删标记, A.操作日期 AS A操作日期, A.产品名称 AS A产品名称, A.数量 AS A数量, A.单价 AS A单价,A1. AS A1, A.销售订单ID AS A销售订单ID FROM 销售订单行 AS A LEFT JOIN AS A1 ON A.销售订单ID=A1. order by A.ID limit 0,20 销售订单行