LEFT JOIN and NULL  
Author Message
RichardRoati





PostPosted: Mon Mar 21 09:56:33 CST 2005 Top

SQL Server Developer >> LEFT JOIN and NULL

Hi!

How I can return 0 instead of NULL when using LEFT JOIN?

Thank you!
James

SQL Server182  
 
 
Itzik





PostPosted: Mon Mar 21 09:56:33 CST 2005 Top

SQL Server Developer >> LEFT JOIN and NULL COALESCE(col_name, 0)

--
BG, SQL Server MVP
www.SolidQualityLearning.com




> Hi!
>
> How I can return 0 instead of NULL when using LEFT JOIN?
>
> Thank you!
> James
>


 
 
Aaron





PostPosted: Mon Mar 21 09:55:42 CST 2005 Top

SQL Server Developer >> LEFT JOIN and NULL COALESCE(column_name, 0)

ISNULL(column_name, 0)

--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.






> Hi!
>
> How I can return 0 instead of NULL when using LEFT JOIN?
>
> Thank you!
> James
>
>


 
 
David





PostPosted: Mon Mar 21 09:58:31 CST 2005 Top

SQL Server Developer >> LEFT JOIN and NULL Use COALESCE or ISNULL:

SELECT A.au_id, COALESCE(T.au_id,0)
FROM Authors AS A
LEFT JOIN TitleAuthor AS T
ON A.au_id = T.au_id

--
David Portas
SQL Server MVP
--

 
 
James





PostPosted: Mon Mar 21 10:00:25 CST 2005 Top

SQL Server Developer >> LEFT JOIN and NULL THANKS!

James