第一个sql：SELECT opohPurchaseOrder AS purchaseorderopohPurchaseOrderType AS purchaseordertypeopohSupplier AS supplier opohPurchasingOrganization AS purchasingorganiz

合并后的SQL：

SELECT opoh.PurchaseOrder AS purchaseorder,opoh.PurchaseOrderType AS purchaseordertype,opoh.Supplier AS supplier, opoh.PurchasingOrganization AS purchasingorganization,opoh.PurchasingGroup AS purchasinggroup,opoh.CompanyCode AS companycode, opoh.PaymentTerms AS paymentterms,opoh.ZZ1_PosttingDate_PDH AS create_time,opoh.ZZ1_PosttingDate_PDH AS zZ1PosttingDatePDH, opoh.ZZ1_PosttingDate_PDH AS posttingdate,opoh.DocumentCurrency AS documentCurrency,os.BusinessPartnerName AS supplierName, opoh.zz1bedatpdhpdh as zz1bedatpdhpdh, omh.MaterialDocument, omh.MaterialDocumentYear, omh.CreationDate, omh.CreationTime, omi.GoodsMovementType FROM ods_purchase_order_header opoh LEFT JOIN ods_supplier os ON os.Supplier = opoh.Supplier LEFT JOIN ods_materialdocument_head omh ON omh.PurchaseOrder = opoh.PurchaseOrder LEFT JOIN ods_materialdocument_item omi ON omi.MaterialDocument = omh.MaterialDocument AND omi.MaterialDocumentYear = omh.MaterialDocumentYear LEFT JOIN vmi_materialdocument vmi ON omi.MaterialDocument != vmi.MaterialDocument AND omi.MaterialDocumentYear != vmi.MaterialDocumentYear WHERE opoh.PurchaseOrderType = 'Z012' AND opoh.PurchaseOrder IN (${purchaseOrders}) AND (omi.IsAutomaticallyCreated != 'X' OR omi.IsAutomaticallyCreated IS NULL) AND omi.GoodsMovementType IN (SELECT gmt.GoodsMovementType FROM goodsmovement gmt) ORDER BY opoh.PurchaseOrder, omh.CreationDate, omh.CreationTime