insert into xxxx ( select XXX from YYY where ??? )

prova a usare le parentesi