Thankz. I'll try it out   
      
   On Tue, 20 Mar 2007 10:37:09 -0400, "Larry DiGiovanni"   
    wrote:   
      
   > 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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)