Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Search results for query: *

  1. paperjam

    Using "UNION" in a SQL statement

    I'm trying to use the "union" between 2 sql statements, not sure how the group by feature should be placed, for example: I'd like to put A next to B in a report....... Select "field1", "field2", SUM("field3") AS "A" From "table" Where "field2"=1 UNION Select "field1", "field2", SUM("field3")...

Part and Inventory Search

Back
Top