0

Here is my query:

DROP TABLE table_name

-- Create the multiset table to store product line owner information
CREATE MULTISET TABLE table_name (
    Product VARCHAR(100),
    Owner VARCHAR(100),
    Email VARCHAR(100)
);

-- Insert sample data into the table
INSERT INTO table_name (Product, Owner, Email)
VALUES ('Product', 'Owner Name', 'owner.name@email.com'),
       ('Product1', 'Owner Name1', 'owner1.name@email.com');

-- Retrieving data from the table
SELECT * FROM table_name;

Here is the error that I'm getting:

[Teradata Database] [3706] Syntax error: expected something between ')' and ','.

If I try running it with the second row it works. It doesn't like the comma at the end of the closing parenthesis.

0 Answers0