合并两个SQL语句，获取采购订单信息和入库日期

合并后的SQL如下：\n\nSELECT\n opoh.PurchaseOrder AS purchaseorder,\n opoh.PurchaseOrderType AS purchaseordertype,\n opoh.Supplier AS supplier,\n opoh.PurchasingOrganization AS purchasingorganization,\n opoh.PurchasingGroup AS purchasinggroup,\n opoh.CompanyCode AS companycode,\n opoh.PaymentTerms AS paymentterms,\n opoh.ZZ1_PosttingDate_PDH AS create_time,\n opoh.ZZ1_PosttingDate_PDH AS zZ1PosttingDatePDH,\n opoh.ZZ1_PosttingDate_PDH AS posttingdate,\n opoh.DocumentCurrency AS documentCurrency,\n os.BusinessPartnerName AS supplierName,\n opoh.zz1bedatpdhpdh AS zz1bedatpdhpdh,\n omh.PostingDate\nFROM\n ods_purchase_order_header opoh\nLEFT JOIN\n ods_supplier os ON os.Supplier = opoh.Supplier\nLEFT JOIN\n ods_materialdocument_item omi ON omi.PurchaseOrder = opoh.PurchaseOrder\nLEFT JOIN\n ods_materialdocument_head omh ON omh.MaterialDocument = omi.MaterialDocument AND omh.MaterialDocumentYear = omi.MaterialDocumentYear\nLEFT JOIN\n vmi_materialdocument vmi ON omi.MaterialDocument != vmi.MaterialDocument AND omi.MaterialDocumentYear != vmi.MaterialDocumentYear\nWHERE\n opoh.PurchaseOrderType = 'Z012'\n AND (omi.IsAutomaticallyCreated != 'X' OR omi.IsAutomaticallyCreated IS NULL)\n AND omi.GoodsMovementType IN (SELECT gmt.GoodsMovementType FROM goodsmovement gmt)\nORDER BY\n opoh.PurchaseOrder,\n opoh.ZZ1_PosttingDate_PDH,\n omi.CreationDate,\n omi.CreationTime;