title: How Can I use Two DataSources in a CFQUERY
body: <pre><code> &lt;cfquery name="checkinvoice" datasource="?"&gt;
      SELECT DISTINCT INVOICE_DATE,DEPARTMENT,VALUE,INVOICE_NO 
      FROM   ro_invoice 
      WHERE  sheet_no='#newROSheet.sheetNo#'
      MINUS
      SELECT DISTINCT INVOICE_DATE,DEPARTMENT,VALUE,INVOICE_NO 
      FROM   dbowner.rs_invoices 
      WHERE  rs_id ='#recordSheet.id#'
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>In the above code the 1st <code>select</code> statement belongs to <code>datasource1</code> and the 2nd to <code>datasource2</code> (in oracle). How can I use cfquery to execute the two statements?</p>