السلام عليكم

يا جماعه انا كنت عايزة اعرف ازاى ادمج او اجمع كذا query فى QUERY واحدة

اذا كانت بتاخد من نفس الجداول بس ال SELECT ,WHERE CODITIONS مختلفين

دى حاجه وحاجه تانيه لوفى حالة ان  الGROUP BY مختلف ينفع اجمعهم ولا لأ ويا ريت بمثال بعد اذنكم

شكرا

وللعلم انا الQUERIES دى هحطها فى ريبورتات

السلام عليكم

ابحثي في الانترنت او في المنتدى عن Nested Select ستجد ملايين الأمثلة.

او ضعي الـ Queries وسيتم حل المشكلة.

 

بالتوفيق.

 

here is an example of 3 queries that i want to collect them into one report

 

**first query

SELECT AP_INVOICES_ALL.INVOICE_NUM, AP_INVOICES_ALL.INVOICE_CURRENCY_CODE, AP_INVOICES_ALL.INVOICE_DATE, AP_INVOICES_ALL.DESCRIPTION, AP_INVOICES_ALL.PAY_GROUP_LOOKUP_CODE, AP_INVOICES_ALL.CREATION_DATE, AP_INVOICES_ALL.ATTRIBUTE1, PO_VENDORS.VENDOR_NAME, PO_VENDORS.SEGMENT1, PO_VENDORS.VENDOR_TYPE_LOOKUP_CODE, PO_VENDORS.ATTRIBUTE12, AP_INVOICES_ALL.INVOICE_AMOUNT-AP_INVOICES_ALL.AMOUNT_PAID, AP_INVOICES_ALL.INVOICE_AMOUNT, AP_INVOICES_ALL.AMOUNT_PAID

FROM AP.AP_INVOICES_ALL AP_INVOICES_ALL, AP.AP_SUPPLIERS PO_VENDORS

WHERE ( ( PO_VENDORS.VENDOR_ID = AP_INVOICES_ALL.VENDOR_ID ) )

 AND ( PO_VENDORS.PAY_DATE_BASIS_LOOKUP_CODE BETWEEN '01-JAN-2011' AND '15-jan-2011' )

 AND ( AP_INVOICES_ALL.ORG_ID = '2' )

  AND ( AP_INVOICES_ALL.PAYMENT_STATUS_FLAG <> 'N' )

   AND ( AP_INVOICES_ALL.INVOICE_NUM NOT LIKE '%A%' )

    AND ( AP_INVOICES_ALL.SOURCE = 'AZLG_NC_COMM' )

     AND ( AP_INVOICES_ALL.INVOICE_AMOUNT <> '0' )

ORDER BY PO_VENDORS.SEGMENT1 ASC, AP_INVOICES_ALL.INVOICE_NUM ASC;

**second query

---SELECT AP_INVOICES_ALL.ATTRIBUTE2, AP_INVOICES_ALL.ATTRIBUTE10, PO_VENDORS.VENDOR_NAME, PO_VENDORS.SEGMENT1, SUM(AP_INVOICES_ALL.AMOUNT_PAID), SUM(AP_INVOICES_ALL.INVOICE_AMOUNT)

SELECT AP_INVOICES_ALL.ATTRIBUTE2, AP_INVOICES_ALL.ATTRIBUTE10, PO_VENDORS.VENDOR_NAME, PO_VENDORS.SEGMENT1, SUM(AP_INVOICES_ALL.AMOUNT_PAID), SUM(AP_INVOICES_ALL.INVOICE_AMOUNT)

FROM AP.AP_INVOICES_ALL AP_INVOICES_ALL, AP.AP_SUPPLIERS PO_VENDORS

WHERE ( ( PO_VENDORS.VENDOR_ID = AP_INVOICES_ALL.VENDOR_ID ) )

AND ( (  ( AP_INVOICES_ALL.ATTRIBUTE10 = '11' OR AP_INVOICES_ALL.ATTRIBUTE10 = '34' OR AP_INVOICES_ALL.ATTRIBUTE10 = '12' )  ) )

 AND ( AP_INVOICES_ALL.INVOICE_NUM LIKE '%E%' )

 AND ( AP_INVOICES_ALL.PAYMENT_STATUS_FLAG <> 'Y' AND AP_INVOICES_ALL.CANCELLED_BY IS NULL  )

 AND ( AP_INVOICES_ALL.ORG_ID = '1' ) AND ( AP_INVOICES_ALL.INVOICE_DATE BETWEEN :"Beginning Date" AND :"Ending Date" )

 AND ( AP_INVOICES_ALL.INVOICE_CURRENCY_CODE = 'EGP' )

GROUP BY AP_INVOICES_ALL.ATTRIBUTE2, AP_INVOICES_ALL.ATTRIBUTE10, PO_VENDORS.VENDOR_NAME, PO_VENDORS.SEGMENT1

ORDER BY PO_VENDORS.SEGMENT1 ASC, AP_INVOICES_ALL.ATTRIBUTE10 ASC;

***third query

SELECT AP_INVOICES_ALL.INVOICE_NUM, AP_INVOICES_ALL.INVOICE_CURRENCY_CODE, AP_INVOICES_ALL.INVOICE_DATE, AP_INVOICES_ALL.CREATION_DATE, AP_INVOICES_ALL.ATTRIBUTE1, AP_INVOICES_ALL.ATTRIBUTE7, AP_INVOICES_ALL.ATTRIBUTE12, PO_VENDORS.VENDOR_NAME, PO_VENDORS.SEGMENT1, AP_INVOICES_ALL.INVOICE_AMOUNT, AP_INVOICES_ALL.AMOUNT_PAID

FROM AP.AP_INVOICES_ALL AP_INVOICES_ALL, AP.AP_SUPPLIERS PO_VENDORS

WHERE ( ( PO_VENDORS.VENDOR_ID = AP_INVOICES_ALL.VENDOR_ID ) )

AND ( AP_INVOICES_ALL.INVOICE_NUM LIKE '%E%' )

 AND ( AP_INVOICES_ALL.PAYMENT_STATUS_FLAG <> 'Y' AND AP_INVOICES_ALL.CANCELLED_BY IS NULL  )

  AND ( AP_INVOICES_ALL.ORG_ID = '1' )

 AND ( PO_VENDORS.SEGMENT1 = :"Code" )

ORDER BY AP_INVOICES_ALL.CREATION_DATE ASC, AP_INVOICES_ALL.ATTRIBUTE7 ASC, PO_VENDORS.SEGMENT1 ASC;