SELECT SUM and WHERE / Sum of rows for multiple tables in 1 query.

[u214]

Hi, so this is my code right now:

SELECT SUM(Kills) AS g_killz, SUM(Deaths) AS g_deathz, SUM(Level) AS g_admins WHERE Level > 0 FROM Users

The Level part is messing the whole query. How would I get the sum of Level greater than 0.

 

------------

How can I get the SUM of rows from multiple tables in 1 query? Pretty sure a query per table isn't the best thing to do!

[PFMaBiSmAd]

The error in your current query is because the FROM table_name is not in the correct location.

[elite311]

Are all the values you want to sum contained in the users table? or are you storing the users in 1 table and the values in other tables?

[u214]

Alright, for the first question:

 

Kills, Deaths, and Level are all stored in the User's table. I successfully got the Kills and Deaths, but can't get the sum of Levels above 0. Also, if the "FROM".. is in the wrong place, mind explaining / pointing out where it should be? Thanks.

 

Second question:

 

Let's say I have 5 tables. I want to get the # of rows of each table using 1 query.

 

Hope that clears some misunderstandings.

[Barand]

Also, if the "FROM".. is in the wrong place, mind explaining / pointing out where it should be? Thanks.

 

SELECT ... FROM ... WHERE ...

[PFMaBiSmAd]

Let's say I have 5 tables.

 

Since you haven't shown any information about these multiple tables, it's not possible to provide a direct answer. If the tables are related, when you write a query using JOINs, you can sum information the same as if you were querying one table.