anushahanna
asked on
working with NULL values
what is the reason that the select statement does not bring back valid records. seems like the NULL can kill the query from bringing back good results..
-------------------------- ---------
create table one (first tinyint)
insert into one select 1 union select 2 union select 3
create table two (second tinyint)
insert into two select 1 union select NULL
select first from one where first not in (select second from two) -- does not work
drop table one
drop table two
--------------------------
create table one (first tinyint)
insert into one select 1 union select 2 union select 3
create table two (second tinyint)
insert into two select 1 union select NULL
select first from one where first not in (select second from two) -- does not work
drop table one
drop table two
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
really appreciate it..