I'd be shocked if it doesn't work, Vlad, I know it works for me without
problems in Firebird 1.5 (Well, with other table and field names, if you
use reserved words you have to double quote the table and field names).

Though you should write it like Martijn wrote, without any VALUES clause:

insert into USERS2(USER_NAME, USER_ROLE)
select USER_NAME, USER_ROLE from USER

This should work,
Set

Vlad Orlovsky wrote:

> Hi,
>
> That's not working.
>
> I'd like to copy some data from USERS to USERS2 without using temp variables(FOR SELECT ... INTO :TEMP_USER_NAME, TEMP_USER_ROLE.....)
>
> What is the correct syntax for something like this in Firebird 2.0?
>
> insert into USERS2(USER_NAME, USER_ROLE)
> VALUES (
> select USER_NAME, USER_ROLE from USER)
>
> Thanks in advance,
> Vlad
>
>> Is there a way to do this in Firebird 2.0:
>
>
>> SELECT * INTO Employees2 FROM Employees -- SQL Server Syntax
>
>> Employees and Employees2 are identical tables.
>
> insert into employees2
>
> select * from employees
>
> I believe :)