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

10 votes280 views2 answers
Sql pagination offset
SQL
2 votes260 views1 answer
Sql update alias
SQL
3 votes267 views4 answers
Stop MySQL
SQL
11 votes304 views1 answer
Oracle export view ddl
SQL
0 vote304 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
5 votes270 views4 answers
Rollback to in sql
SQL
0 vote263 views1 answer
How to get table current identity value in sql server
SQL
4 votes265 views3 answers
Oracle sql first day of quarter
SQL
28 votes246 views4 answers
Mysql delete database
SQL
0 vote266 views1 answer
Mysql error 1251
SQL