title: Need to speed up the results of this SQL statement. Any advice?
body: <p>I've got the following SQL Statement that needs some major speed up.  The problem is I need to search on two fields, where each of them is calling several sub-selects.  Is there a way to join the two fields together so I call the sub-selects only once?</p>
  
  <pre><code>SELECT billyr, billno, propacct, vinid, taxpaid, duedate, datepif, propdesc
  FROM trcdba.billspaid
  WHERE date(datepif) &gt; '01/06/2009'
  AND date(datepif) &lt;= '01/06/2010'
  AND custno in
   (select custno from cwdba.txpytaxid where taxpayerno in
    (select taxpayerno from cwdba.txpyaccts where accountno in
     (select accountno from rtadba.reasacct where controlno = 1234567)))
  OR custno2 in
   (select custno from cwdba.txpytaxid where taxpayerno in
    (select taxpayerno from cwdba.txpyaccts where accountno in
     (select accountno from rtadba.reasacct where controlno = 1234567)))
  </code></pre>