Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
8 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Using left outer join in SQL
Posted on 2012-12-31
select table1.column_id,
table1.column_type,
table2.column_name
from table1
left outer join table2
on table1.column_type = table2.column_numb
In Table 1
column_id column_type
1 NULL
2 NULL
3 300
In Table 2
table2_column_id column_numb column_name
1 100 ABC
2 200 DEf
3 300 GHI
Expected value
column_id column_type column_name
1 NULL NULL
2 NULL NULL
3 300 GHI
My query is not picking the NULL Values. What could be the reason ??
table1.column_type,
table2.column_name
from table1
left outer join table2
on table1.column_type = table2.column_numb
In Table 1
column_id column_type
1 NULL
2 NULL
3 300
In Table 2
table2_column_id column_numb column_name
1 100 ABC
2 200 DEf
3 300 GHI
Expected value
column_id column_type column_name
1 NULL NULL
2 NULL NULL
3 300 GHI
My query is not picking the NULL Values. What could be the reason ??
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
Active 1 day ago
looks good for me : see test code
check your tables datatype
check your tables datatype
use test
go
create table Table1 (column_id int, column_type int)
go
insert into Table1
select 1 , NULL
union all select 2 , NULL
union all select 3 , 300
go
create table Table2 (table2_column_id int, column_numb int, column_name varchar(50))
insert into table2
select 1 , 100 , 'ABC'
union all select 2 , 200 , 'DEf'
union all select 3 , 300 , 'GHI'
go
select table1.column_id,
table1.column_type,
table2.column_name
from table1
left outer join table2
on table1.column_type = table2.column_numb
Active 1 day ago
You say my query works fine. i actually mentioned the sample data.
i implemented same logic query in my production database, but records with null value is filtered.
i implemented same logic query in my production database, but records with null value is filtered.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Course of the Month8 days, 22 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.