Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sqlhelpme

  1. sqlhelpme

    several SUMs in one query each using different tables

    I know how to get a sum in a query, but I need several different sums with different where clauses all in one query. Is that possible? I.e. want, region, code, name, sum1 (from tableA where 1,2,3), sum2 (from tableB where 2,4,5) I can only get 1 aggregate function to work per query. select...
See more

Part and Inventory Search

Back
Top Bottom