INSERT with SELECT shows a: Error 618: Expected ','

[Srinivas Yalamarti]

Hi,

I am trying to execute an INSERT with SELECT SQL using ViSQL.

The insert statement itself works fine - eg.,
             INSERT INTO TABLE_A  (CUST_NAME, CUST_NUM)  VALUES ('jondoe',
100)

The select statement itself works fine - returns rows - eg.,
            SELECT CUST_NAME, CUST_NUM FROM TABLE_B

The two put together doesn't :
            INSERT INTO TABLE_A (CUST_NAME, CUST_NUM) VALUES (SELECT
CUST_NAME, CUST_NUM FROM TABLE_B)

It shows an:  Error 618: Expected ','

Is there anything wrong with the syntax?  Does Valentina support executing
this kind of SQL?

Any input regarding this would be greatly appreciated.


Regards,
Srini Y


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and delete the material from any
computer.