Combine two tables for one output

by

You’ll need to use UNION to combine the results of two queries. In your case:

SELECT ChargeNum, CategoryID, SUM(Hours)
FROM KnownHours
GROUP BY ChargeNum, CategoryID
UNION ALL
SELECT ChargeNum, 'Unknown' AS CategoryID, SUM(Hours)
FROM UnknownHours
GROUP BY ChargeNum

Note – If you use UNION ALL as in above, it’s no slower than running the two queries separately as it does no duplicate-checking.

More Related Contents:

  1. What is the difference between UNION and UNION ALL?
  2. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  3. What is the difference between JOIN and UNION?
  4. How to order by with union in SQL?
  5. SQL Query – Using Order By in UNION
  6. Way to try multiple SELECTs till a result is available?
  7. Support UNION function in BigQuery SQL
  8. SQL Server UNION – What is the default ORDER BY Behaviour
  9. Merge two rows in SQL
  10. UNION the results of multiple stored procedures
  11. What are the options for storing hierarchical data in a relational database?
  12. Splitting string into multiple rows in Oracle
  13. SQL JOIN vs IN performance?
  14. Microsoft Jet wildcards: asterisk or percentage sign?
  15. Pivoting data in MS Access
  16. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  17. Combining the results of two SQL queries as separate columns
  18. How do I delete a fixed number of rows with sorting in PostgreSQL?
  19. How to check if a string is a uniqueidentifier?
  20. Use cases for NoSQL [closed]
  21. Alter user defined type in SQL Server
  22. Deferrable Constraints in SQL Server
  23. Use Access SQL to do a grouped ranking
  24. How do I get textual contents from BLOB in Oracle SQL
  25. SQL Server equivalent to MySQL enum data type?
  26. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  27. Counting the number of occurrences of a substring within a string in PostgreSQL
  28. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  29. Challenge,how to implement an algorithm for six degree of separation?
  30. UPSERT *not* INSERT or REPLACE

Leave a Comment