antico5/update_joined_table.rb

Created May 18, 2018 14:02

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/antico5/19f5a25bb1c4b05706092436a279880c.js"></script>
Save antico5/19f5a25bb1c4b05706092436a279880c to your computer and use it in GitHub Desktop.

Download ZIP

Update on joined table PostgreSQL

Raw

update_joined_table.rb

Delivery.connection.update('UPDATE deliveries AS d SET customer_num = u.customer_num FROM users AS u WHERE d.customer_id = u.customer_id')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment