SQL LEFT JOIN return 0 rather than NULL

sql null left-join
Karl picture Karl · Jun 24, 2009 · Viewed 59.8k times · Source

I want to join two tables, with the number of records for each type being counted. If there are no records of that type in the left table I want a 0 to be returned, not a null.

How can I do this?

Answer

cjk picture cjk · Jun 24, 2009

Use:

ISNULL(count(*), 0)

Related questions

Select rows which are not present in other table

I've got two postgresql tables: table name column names ----------- ------------------------ login_log ip | etc. ip_location ip | location | hostname | etc. I want to get every IP address from login_log which doesn't have a row in ip_location. I …

Read More
Mysql Left Join Null Result

I have this query SELECT articles.*, users.username AS `user` FROM `articles` LEFT JOIN `users` ON articles.user_id = users.id ORDER BY articles.timestamp Basically it returns the list of articles and the username that the article is associated …

Read More
How to use NULL or empty string in SQL

I would like to know how to use NULL and an empty string at the same time in a WHERE clause in SQL Server. I need to find records that have either null values or an empty string. Thanks.

Read More