Trying to run the sql code below -
Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 5554 StartFragment: 314 EndFragment: 5522 StartSelection: 314 EndSelection: 314SyntaxEditor Code Snippet
CREATE MULTISET TABLE NRR_XBUY_4 AS(SELECT a.Delv_Month, a.alloc_id, CAST(b.Total_Bookings AS DEC(15,6)) / CAST(a.Total_Dlv AS DEC(15,6)) * 100 *100 AS NRR_XBUY FROM Total_Delivered a Inner Join Total_Bookings b ON a.alloc_id = b.booking_lob and a.Delv_Month = b.Delv_Month Group by 1,2) WITH DATA PRIMARY INDEX(a.Delv_Month);
Error Message: CREATE TABLE Fasiled 3706: syntax error: expected something between the word 'a' and '.'.
A table name is not allowed on the column name in the INDEX definition. Only the column name.