Mysql where sum > 0

Mysql where sum >0

 SELECT user.id, CONCAT(lastname, firstname), year, month, date FROM user
LEFT JOIN adoption ON user.id = adoption.adopter
GROUP BY user.id
HAVING SUM(CONCAT(year,month,date) = '2016618') = 0

Source: stackoverflow.com

Similar codes

0 vote182 views1 answer
Psql datestyle
SQL
0 vote182 views1 answer
Psql select * from table
SQL
2 votes171 views1 answer
Mysql select random id from table
SQL
1 vote178 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote181 views1 answer
Oracle DROP PROGRAM
SQL
0 vote180 views1 answer
Test the postgresql db connection
SQL
4 votes174 views1 answer
Mysql ip address
SQL
0 vote177 views1 answer
How to check even or odd in sql
SQL
0 vote194 views1 answer
Sql filter rows with condition
SQL
0 vote185 views1 answer
How to tell if i have lactose intolerance
SQL