UPDATE table_to_be_updated
SET column=subquery.column
FROM (SELECT column, id
FROM /* big hairy SQL */ ...) AS subquery
WHERE table_to_be_updated.id=subquery.idid;
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.
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.