SQL for Status Ids

UPDATE vehicle v SET v.status_id = 23 WHERE id IN (SELECT vehicle_id FROM contracts WHERE status_id = 20)

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.