CREATE TABLE Failed. 3706: Syntax error: expected something between ')' and '.'

Analytics
Enthusiast

CREATE TABLE Failed. 3706: Syntax error: expected something between ')' and '.'

I am trying to join the 3 tables, to find the Customers present in Table 1 and not in Table3 for the given conditions ( LOBs & Delivery date) Its throwing an error....

 

 

 

 

CREATE MULTISET VOLATILE TABLE ABCD_02 AS ( Select B.cust_id, B.acct_id, B.dlv_dt, F.alloc_id FROM TABLE_1 B INNER JOIN TABLE_2 F ON B.EMAIL_ID = F.EMAIL_ID WHERE F.ALLOC_ID IN ('360_xb','bank_xb', 'coaf_xb', 'HE_XB', 'mort_xb', 'inv_xb') AND B.dlv_dt Between '2016-07-25' and '2016-08-31') LEFT OUTER JOIN Select A.cust_id, A.acct_id, A.allocation_lob From TABLE_3 A ON B.CUST_ID = A.CUST_ID AND B.ACCT_ID = A.ACCT_ID AND F.alloc_id = A.allocation_lob Where A.CUST_ID IS NULL

Accepted Solutions
Junior Supporter

Re: CREATE TABLE Failed. 3706: Syntax error: expected something between ')' and '.'

with data is missing and also you show on commit preserve rows. Please see the example below

 

create multiset volatile table test as
(SELECT * from xyz) with data no primary index on commit preserve rows

 

1 ACCEPTED SOLUTION
1 REPLY
Junior Supporter

Re: CREATE TABLE Failed. 3706: Syntax error: expected something between ')' and '.'

with data is missing and also you show on commit preserve rows. Please see the example below

 

create multiset volatile table test as
(SELECT * from xyz) with data no primary index on commit preserve rows