Results 1 to 4 of 4

Thread: Need Help with SQL Query Syntax for Complex Join and Aggregation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-26-2024, 10:10 PM #3
    June7
    June7 is offline
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    443
    Location
    What does "-- Additional aggregation and grouping logic" mean - more calculated fields?

    "total quantity ordered overall" means total for all products in given range? You want this total shown on every record? Think have to build query for product aggregation, a query for total aggregation, then OUTER JOIN those queries. Each of those queries will need same filter criteria.

    You are building this query in SSMS? What are you using for GUI - Access? Consider building a report and doing Sorting & Grouping and aggregate calcs there.
    Last edited by June7; 06-26-2024 at 10:31 PM.
    How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules