Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › SQL statement problem

SQL statement problem

Thread began 8/29/2021 10:23 am by birdscreen398247 | Last modified 8/29/2021 11:48 am by Ray Borduin | 393 views | 2 replies |

8/29/2021 10:23 am | #1 birdscreen398247

SQL statement problem

I am trying to use SUM in a repeat region sql statement that produces a list like this:

John Smith 1023
Bob Brown 956
Mary Smith 854

For each name, there are multiple records that match the SELECT statement (CountType='Life' AND CountArea='County'), but I only want one record displayed for each name with the SUM(Quantity) of all of those records for that name.

I can't figure out how to do that.

See the attached file for what I have done so far.

Attached Files

TotalTicksTest.php

8/29/2021 10:28 am | #2 Ray BorduinWebAssist

Try:

SELECT SUM(Quantity), FullName FROM birdlists WHERE birdlists.CountType='Life' AND birdlists.CountArea='County' GROUP BY FullName ORDER BY SUM(Quantity) DESC

Did this help? Tips are appreciated...

8/29/2021 10:58 am | #3 birdscreen398247

Thanks. That worked.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.