home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 8,307 of 9,834   
   Hotmail.com to nospam@nospam.com   
   Re: Paradox 5 (Win)   
   20 Mar 07 15:50:03   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca