Use column from Q1 as parameter on Q2

Hi

From an xml data definition, I have two dataQuery (Q1 and Q2) I want to use a column from Q1 as a parameter in Q2

Here's a sample of my code:

<sqlStatement name="Q1">

<![CDATA[

        select c_vendor_name SUPPLIER,

               c_upper_vendor_name SUPPLIER_MAYUS,

               c_sort_vendor_name SUPPLIER_SORT,

               c_invoice_num INVOICE_NUM,

               c_invoice_date INVOICE_DATE,

               c_invoiceid INVOICE_ID,

              ....

       from .....

   ]]>

</sqlStatement>

</sqlStatement>

   <sqlStatement name="Q2">

     <![CDATA[

        SELECT

              aip.invoice_id INVOICE_ID,

              DECODE(AIP.INVOICE_PAYMENT_TYPE,'PREPAY', ALC1.DISPLAYED_FIELD, iby.payment_method_name) PAYMENT_METHOD ,

              DECODE(AIP.INVOICE_PAYMENT_TYPE,'PREPAY', AI2.INVOICE_NUM, AC.CHECK_NUMBER) DOCUMENT_NUMBER ,