teradata insert command issue

[gsai78]

I am trying to insert data into one table in teradata from another and receiving syntax error msg.[3707] some operator expected between ')' and 'from'


can somebody help where am I going wrong -


here's query -
Insert into BI_DW.SSI_Calls2care
Values
(
select
dim_device_id
,date_yyyymm


,sum(call_cnt)
,sum(start_base)
,sum(end_base)
from call_join

group by 1,2,3
order by 1,2,3

 

[whitestorm]

Are there only 5 fields in SSI_Calls2care?
If yes,Try this:

Insert into BI_DW.SSI_Calls2care
select
dim_device_id
,date_yyyymm
,sum(call_cnt)
,sum(start_base)
,sum(end_base)
from call_join
group by 1,2;

 

[tarunteradata]

You have not closed the parenthesis.
you have started writing the select statement inside parenthesis and did not closed it,so try by closing it.