LEFT JOIN and NULL
Index
‹
SQL Server
‹
SQL Server Developer
Author
Message
RichardRoati
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: Mon Mar 21 10:00:25 CST 2005
Top
SQL Server Developer >> LEFT JOIN and NULL THANKS!
James
Index
‹
SQL Server
‹
SQL Server Developer