Delete query that doesn't work ?

Hi!

Do you know why this query is ok on SQL 2005 and not on SQL ce ?

Code Snippet

DELETE ProfilesGroups

FROM ProfilesGroups pg

INNER JOIN Groups g

ON tpGroupID = g.gId

WHERE pg.tpProfileID = '7df60fae-a026-4a0b-878a-0dd7e5308b09'

AND g.gProfileID = '8a6859ce-9f99-4aaf-9ed6-1af66cd15894'

Thx for help ;-).

PlaTyPuS

You can only reference a single table in a delete statement on SQL CE - a SQL CE limitation :-)