I need a help in TERADATA

[Shrutisinha]

I have 2 tables baseline and weekly, baseline is master table andi update baseline by weekly but comparing the new records in the weekly tablle
can somebody help me i have ban number in both the tables and end_date in the baseline table , once the ban is out from the weekly table it get end date in teh baseline table saying that ban is out , now if the ban come back in weekly table with new strat date how do i insert the record in baseline
My query don't work , i donno whats wrong ??

INSERT Into cc.Baseline
(Strt_dt,BALANCE,BAN,FIRST_NM)
Select b.Sys_dt,b.BALANCE,b.BAN,b.FIRST_NM
From cc.Baseline a
Right OUTER JOIN cc.Weekly b
On a.BAN=b.BAN
Where a.BAN is NULL
And a.End_dt is Null

[vijaydiwakar]

I have 2 tables baseline and weekly, baseline is master table andi update baseline by weekly but comparing the new records in the weekly tablle
can somebody help me i have ban number in both the tables and end_date in the baseline table , once the ban is out from the weekly table it get end date in teh baseline table saying that ban is out , now if the ban come back in weekly table with new strat date how do i insert the record in baseline
My query don't work , i donno whats wrong ??

INSERT Into cc.Baseline
(Strt_dt,BALANCE,BAN,FIRST_NM)
Select b.Sys_dt,b.BALANCE,b.BAN,b.FIRST_NM
From cc.Baseline a
Right OUTER JOIN cc.Weekly b
On a.BAN=b.BAN
Where a.BAN is NULL
And a.End_dt is Null

where is the values clause

[Shrutisinha]

where is the values clause

well u don't need value clause when u are using select statment

[vijaydiwakar]

I have 2 tables baseline and weekly, baseline is master table andi update baseline by weekly but comparing the new records in the weekly tablle
can somebody help me i have ban number in both the tables and end_date in the baseline table , once the ban is out from the weekly table it get end date in teh baseline table saying that ban is out , now if the ban come back in weekly table with new strat date how do i insert the record in baseline
My query don't work , i donno whats wrong ??

INSERT Into cc.Baseline
(Strt_dt,BALANCE,BAN,FIRST_NM)
Select b.Sys_dt,b.BALANCE,b.BAN,b.FIRST_NM
From cc.Baseline a
Right OUTER JOIN cc.Weekly b
On a.BAN=b.BAN
Where a.BAN is NULL
And a.End_dt is Null

 
INSERT    Into cc.Baseline 
(Strt_dt,BALANCE,BAN,FIRST_NM)
Select    b.Sys_dt,b.BALANCE,b.BAN,b.FIRST_NM
From    cc.Baseline a,
 cc.Weekly b,
 
Where    
a.BAN=b.BAN(+) and 
a.BAN is NULL
And a.End_dt is Null
 

try this