Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Course Of The Month
3 days, 14 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 5 days 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
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
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses
Course of the Month3 days, 14 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.