insert into from where order by ?

[mather]

i am geting error for the following command from vb6
insert into table1 from select * from table2 where <condition> order by field1

[rectoverso]

i am geting error for the following command from vb6
insert into table1 from select * from table2 where <condition> order by field1

try this

insert into table1 using (select * from table2 where <condition> order by field1 )

[vijaydiwakar]

i am geting error for the following command from vb6
insert into table1 from select * from table2 where <condition> order by field1

what's d error?

[Dave44]

what's d error?

looking at the statement he provided it looks like the "from" keyword is what is wrong.