How do I add two count(*) results together on two different tables?

by

Wrap them up and use subqueries:

SELECT
(SELECT COUNT(*) FROM Toys WHERE little_kid_id = 900)+
(SELECT COUNT(*) from Games WHERE little_kid1 = 900 
                              OR little_kid2 = 900 
                              OR little_kid3 = 900)
AS SumCount

Voila!

More Related Contents:

  1. Complex Count in MySQL
  2. Most efficient way to get table row count
  3. MySql Count cannot show 0 values
  4. Speeding up row counting in MySQL
  5. Order by COUNT per value
  6. Mysql count instances of substring, then order by
  7. mysql: get record count between two date-time
  8. MYSQL sum() for distinct rows
  9. COUNT(*) from multiple tables in MySQL
  10. Why the rows returns by “explain” is not equal to count()?
  11. How to get the count of each distinct value in a column? [duplicate]
  12. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  13. MYSQL Left Join COUNTS from multiple tables
  14. MySQL sum elements of a column
  15. Count with IF condition in MySQL query
  16. MySQL – Using COUNT(*) in the WHERE clause
  17. Surpassing MySQL’s TIME value limit of 838:59:59
  18. Sum until certain point – MySql
  19. Mysql Counting the consecutive rows that match
  20. Change MySQL default character set to UTF-8 in my.cnf?
  21. MySQL offset infinite rows
  22. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  23. How do write IF ELSE statement in a MySQL query
  24. How do you uninstall MySQL from Mac OS X?
  25. How to program a MySQL trigger to insert row into another table?
  26. Check if a column exists in a table with MySQL
  27. Connect to Docker MySQL container from localhost?
  28. How to start MySQL server from command line on Mac OS Lion?
  29. MySQL: set field default value to other column
  30. CREATE command denied to user？

Leave a Comment