Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 27 Oct 2002 @ 21:57:51 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Compare null with integer
 
From:   sreya malladi

Hi,

I want to compare null with integer. Here I am sending example what I need to do. I have table a, table B and table c

Table A, B, c are look like this

(acct_id integer,
acct_type integer
acct_map char(3) ).

Tables have the values like this
acct_id     acct_type  acct_map
1234        null        ABC

B table have the valus like this
acct_id     acct_type  acct_map
1234         3         lkm
1234         2         abs

I am wanted to insert like this

insert into c
Sel a.acct_id,b.acct_type
From a, b
Where a.acct_id = b.acct_id
and a.acct_type <>b.acct_type;

i am expecting row like this

1234    null   abc

but sql returns no rows.

please help me on this

sreya



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016