From: nospam@nospam.com   
      
    wrote:   
      
   > I want to get all the records (including dubblets) in DB1 and then get   
   > the Count to summerize a total count. Then I want to calc the total   
   > Count with Price (without dubblets).   
      
   This is easy if BarCode is unique in DB2:   
      
   Untested, but:   
      
   SELECT a.BarCode, SUM(a."Count") AS TotalCount, b.Price   
     FROM DB1 a INNER JOIN DB2 b on (a.Barcode = b.Barcode)   
   GROUP BY BarCode, Price   
      
   or   
      
   DB1 | BarCode  | Count         |   
       | _a       | CALC SUM      |   
      
   DB2 | Barcode  | Text | Price |   
       | _a       |      | Check |   
      
   If this isn't what you're looking for, let us know.  It's best if you post   
   some sample data (as text, not attachments) and what the corresponding   
   answer table would be.   
      
   --   
   Larry DiGiovanni   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)