I work with SQL server and Fox. Does Fox allow the following Insert Select statement?

insert into terrcounts (territoryno,count) select teritoryno,count(*) as count from call_list group by teritoryno.

I get a syntax error when I do this. Is it the incorrect syntax or , is it that, Fox will not allow this?