Archives of the TeradataForum

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

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

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>>