|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/5/2007 4:41:45 PM
Posts: 1,
Visits: 6
|
|
I need to updata column in target table.
1. source table
2. Lkp table
3. target table
the query i wrote is not working can any one help me out.
update target.table
from( select lkptable.clm1,srctable.clm2 from lkptable,srctable
where
lkp.clm3=src.clm3
lkp.clm4=src.clm4
lkp.clm5=src.clm5
lkp.clm6=src.clm6
lkp.clm7=src.clm7
lkp.clm8=src.clm8) as c
set target.clm1 = c.clm1
where target.clm2 = c.clm2
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 8/26/2008 4:53:36 PM
Posts: 50,
Visits: 220
|
|
From your question I didn't get what you are looking for..
You may try this logic.. that should work..
update target
SET clm1 = lkp.clm1
WHERE EXISTS ( Select 1
from lkp,src
where lkp.clm3=src.clm3
lkp.clm4=src.clm4
lkp.clm5=src.clm5
lkp.clm6=src.clm6
lkp.clm7=src.clm7
lkp.clm8=src.clm8)
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/28/2007 5:04:36 PM
Posts: 5,
Visits: 4
|
|
The following sql will work
update target.table
from( select lkptable.clm1 x,srctable.clm2 y from lkptable,srctable
where
lkp.clm3=src.clm3
lkp.clm4=src.clm4
lkp.clm5=src.clm5
lkp.clm6=src.clm6
lkp.clm7=src.clm7
lkp.clm8=src.clm8)c
set clm1 = c.x
where clm2 = c.y
|
|
|
|