nem.ec

Programming Information Security Recipes Personal Code Snippets

Update a table with a join

UPDATE u  -- u is the table to be updated
SET u.assid = s.assid 
FROM ud u 
INNER JOIN sale s
ON u.id = s.udid