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);
