如何从完全外部联接中删除空值 [英] how to remove the null values from full outer join

问题描述

朋友，
我是一个新手，试图解决这个问题.我用谷歌搜索，但没有得到答案.如何从完全外部联接中删除空值.

我尝试了这个但没有用.
从

Hi friends,
I am a novice trying to get around this issue. I googled but did not get the answer. How to remove the null values from full outer join.

I tried this but not working.

select emp.name , employee.name from emp full join employee on  ISNULL(emp.name, 0) = ISNULL(employee.name, 0)

我的问题是:我不想在结果为NULL的任何地方显示NULL，而我想看到的是"0".
请帮忙！

My problem is that : I don''t want to show the NULL wherever the result is NULL, instead i want to see ''0''.
Please help!

推荐答案

1.无法等于NULL列= sql服务器中的另一个Null Vlaue.

因此，只需尝试一下.

从emp中选择emp.name，employee.name
emp.name上的完全加入员工为NULL
并且employee.name为NULL



如果您没有得到答案，请提供有关您的问题的详细信息.


问候，
Saran.t

Hi ,



1. not possible to equal a NULL column = Another Null Vlaue in sql server.

So just try this..

select emp.name , employee.name from emp
full join employee on emp.name is NULL
and employee.name is NULL



if u dont get an answer, pls give a details about your problem.


Regards,
Saran.t

这是您想要的吗?

Is this what you want?

select ISNULL(emp.name, '0') as [emp.name],
       ISNULL(employee.name, '0') as [employee.name]
from   emp
full
join   employee
       on ISNULL(emp.name, '0') = ISNULL(employee.name, '0')

这篇关于如何从完全外部联接中删除空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！