teradata insert command issue
teradata insert command issue
(OP)
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
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
Talk To Other Members
RE: teradata insert command issue
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;
RE: teradata insert command issue
you have started writing the select statement inside parenthesis and did not closed it,so try by closing it.