Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Compare null with integer
From:   sreya malladi


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


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