以下如何错呀,,,
select hdAMR_d.zid,hdAMR_d.zMcode,hdAMR_d.zReq_Qty ,hdMaterialInfo.zMname,hdMaterialInfo.zSpecification,hdMaterialInfo.zUnit,hdMaterialInfo.zMatCategory_Name,hdMaterialInfo.zDrawing from hdAMR_d left OUTER JOIN hdMaterialInfo on hdMaterialInfo.zMcode=hdAMR_d.zMcode and hdAMR_d INNER JOIN hdAMR_m on hdAMR_d.zOrder_ID=hdAMR_m.zMR_ID