Post date: Dec 9, 2013 10:58:20 AM
UPDATE `orders_noticeSB` as onsb
INNER JOIN `orders` AS o ON o.numberOrd=?
SET onsb.DateSMS = NULL, onsb.ID_sendcity=o.ID_sendcity, onsb.ID_recCity = o.ID_reccity, onsb.ID_tariff_type = o.ID_tariff_type
WHERE onsb.NumberOrd=?";