From: pnews@sendto.org   
      
   "Robert Wiltshire"  wrote in message   
   news:492e5e55$1@pnews.thedbcommunity.com...   
   >   
   > What about making this a 2 query process.   
      
   Great suggestion. I did that. It seems we are finding that still not all   
   information from the job table is pulled. Wish I had better information on   
   what is causing this error. Thanks for the suggestion, --Joe   
      
   > Query #1   
   > Using a job key or keys,   
   > simply do a one table query from jobitems,   
   > and rename answer table to temp table.   
   >   
   > Then query #2   
   > Do your 2 table query that you do now...   
   > but do not link 3 times into jobItems that has 1M plus records,   
   > but link to your temp table that was created in Query #1.   
   >   
   > Perhaps this could avoid errors that surface when you have multiple job   
   > keys.   
   >   
   > Good luck   
   > Robert Wiltshire   
   >   
   >   
   >   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)