RE: Interactive SQL question

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Dennis Munro wrote:

>I am trying to find some information on how to "code" column totaling. I
>have a report that selects qty, price, (qty * price) from a file but I
would
>like to total the three columns.  Looked through the Midrange archieves but
>you get tired of looking through 278 entries after 25 & they don't pertain
>to my question.

I can sympathise with the search engine.  The best thing to do there is to
spend some time and play with the keywords.  I have found that two keywords
work the best.  I used SQL TOTAL and quickly found the answer: use UNION.
Here's the link: http://archive.midrange.com/midrange-l/199911/msg00123.html
I have also found that hits less than 4 stars are rarely of interest.  I
only look there when truly desperate.

One thing that definitely hampers the search is the lack of correlation
between the subject and the problem.  This very thread will suffer the same
problem.  A better subject line might be "How do I show detail and total in
a single SQL SELECT?"

Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.midrange.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---