Advertisement
Guest User

Untitled

a guest
Oct 4th, 2015
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. UPDATE outcrop_section
  2. SET description = result.project_id
  3. FROM (
  4. SELECT project.id as project_id, region.id as region_id
  5. FROM model_system AS region
  6. INNER JOIN model_project AS project ON project.id = region.model_project_id
  7. ) result
  8. WHERE result.region_id = outcrop_section.model_system_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement