insert into ... select error

[ovello]

I`m trying to insert some rows of the table [Produse finite dbo_SC03XX00] into the table [Loturi dbo_SC33XX00].

So, I tryed to run the following queries:

A) INSERT INTO [Loturi dbo_SC33XX00] ( [Loturi dbo_SC33XX00].SC33001, [Loturi dbo_SC33XX00].SC33002, [Loturi dbo_SC33XX00].SC33003, [Loturi dbo_SC33XX00].SC33005)
VALUES (select [Produse finite dbo_SC03XX00].SC03001,'01','000000000999',5000 from [Produse finite dbo_SC03XX00]);

But, when I want to save the query I get the following error:

"Syntax error. in query expression 'select [Produse finite dbo_SC03XX00].SC03001'"

B) INSERT INTO [Loturi dbo_SC33XX00] ( [Loturi dbo_SC33XX00].SC33001, [Loturi dbo_SC33XX00].SC33002, [Loturi dbo_SC33XX00].SC33003, [Loturi dbo_SC33XX00].SC33005)
VALUES select [Produse finite dbo_SC03XX00].SC03001,'01','000000000999',5000 from [Produse finite dbo_SC03XX00];

and I get the error:

"Syntax error in INSERT INTO statement."

I thought that the select query might be wrong, so I tested it:

"select [Produse finite dbo_SC03XX00].SC03001,'01','000000000999',5000 from [Produse finite dbo_SC03XX00]"

and it runs correctly.

How can I solve the problem? How can I insert the specified rows from the table [Produse finite dbo_SC03XX00] into the table [Loturi dbo_SC33XX00]?

Thank you in advance.

 

[ovello]

I found the error. I added a "VALUE" keyword in the queries and I shouldn`t. I succeeded in saving the query, but when I want to run it, I get the following error:

"The insert into statement contains the following unknown field name 'Loturi dbo_SC33XX00.SC33001'. Make sure you have typed the name correctly, and try the operation again"

I checked up the field and it is typed correctly. How can I solve the problem?