teradata insert command issue

gsai78 · Sep 4, 2009

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 · Nov 5, 2009

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 · Dec 23, 2009

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

teradata insert command issue

gsai78

IS-IT--Management

whitestorm

Technical User

tarunteradata

Programmer

Similar threads

Part and Inventory Search

Sponsor