Migration MySQL to SSCE...big problems in SQL CE Language...

hello,(sorry for my english language but im french :-) )

I have a lots of problems to convert the SQL language from MySQL to SSCE because the SSCE language is so poor...

If somebody have some URL with a lots of examples of request (select, update).
for example, im not able to convert this update request :

Update reservation,lockers set reservation.ERS_ID='A' where lockers.LCK_CONF!='LW' AND lockers.LCK_PHYS_NO=reservation.LCK_PHYS_NO AND reservation.ERS_ID IN('V','M','E','S','F','D','P');

how to use 2 tables in the same update?
i saw the MSDN but there arent explicit and GOOD examples...
http://msdn2.microsoft.com/fr-fr/library/ms174122.aspx

Thanks you

Hello,

try using

update reservation set ERS_ID = 'A' where ERS_ID IN ('V', 'M', 'E', 'S', ....) and exists

(select 1 from lockers where lockers.LCK_CONF != 'LW' and lockers.LCK_PHYS_NO = reservation.LCK_PHYS_NO);