Hi,

it would be easier if you would describe what the update should do.

So I could only give a guess from the code...

UPDATE K 
 FROM Table_A 
 (
                select a.Column_1,a.Column_2 ,
                          COUNT(*) as Column_3,
                         (SUM(Column_6) +sum(Column_7)) as Column_4  
               from Table_B a inner join   Table_C b 
                                             on a.column_5=b.column_5    
          where  a.Column_1=b.Column_1 
                     and a.Column_2=b.Column_2 
                      and  a.Column_1= 20120601 and a.Column_2=5 
) M
SET Column_3=M.Column_3 
         ,Column_4=M.Column_4  
where --> table_a and derived table M join condition;

So you specify your dervied table in the from clause.

and define in the where clause the join condition between the table_a and the derived table M.

Check the Update syntax diagram in the manuals

What I can see is the the set needs a , instead of an and 

something like 

update k
 
from
cust_zone_sales k,
 
(select main_zone_id, zone_no, sales_count, sales_sum
 
from 
 
(
 
select 1420 as main_zone_id, 17 as zone_no, count(*) as  sales_count, 
 
(sum(usd_amount) + sum(euro_amount) ) as sales_sum 
 
from new_cust_table a
 
inner join new_dealer_table b 
 
on a.prodid = b.prodid
 
where proddescid = 5
 
) b
 
on a.tran_area_id = b.tran_area_id
 
and a.main_zone_id = b.main_zone_id
 
where a.main_zone_id = 1265
 
and a.zone_no = 48
 
and zone_status_flag = 'F'
 
) M
 
set k.sales_count = m.sales_count
 
,k.sales_sum = m.sales_sum
 
where 
 
k.main_zone_id=m.main_zone_id and 
 
k.zone_no= m.zone_no 

Didn't rec it in the last post.

You need to fix your derived table...

on a.tran_area_id = b.tran_area_id

and a.main_zone_id = b.main_zone_id

where a.main_zone_id = 1265

and a.zone_no = 48

and zone_status_flag = 'F'

where is a comming from?

You need to write the derived table M in a way that you can execute it on itself (copy / paste into SQLA) and gives a result set which you can join to the target table.

 [3993 - illegal usage of alias name] occured due to alias name for target table in SET. Rewrite below part,

set k.sales_count = m.sales_count
,k.sales_sum = m.sales_sum

to

set sales_count = m.sales_count
,sales_sum = m.sales_sum

 
UPDATE cust_zone_sales k
FROM
(
SELECT 1420 AS main_zone_id, 17 AS zone_no, COUNT(*) AS sales_count,
(SUM(usd_amount) + SUM(euro_amount) ) AS sales_sum
FROM new_cust_table a
INNER JOIN new_dealer_table b
ON a.prodid = b.prodid
ON a.tran_area_id = b.tran_area_id
AND a.main_zone_id = b.main_zone_id
WHERE a.main_zone_id = 1265
AND a.zone_no = 48
AND zone_status_flag = 'F' AND proddescid = 5
) M
SET k.sales_count = m.sales_count
AND k.sales_sum = m.sales_sum
WHERE
k.main_zone_id=m.main_zone_id AND
k.zone_no= m.zone_no
Thanks,
Venkat