Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- street1, pages: 1,2
- street2, pages: 2,3
- or
- page1, streets: 1,2,3,5
- page2, streets: 2,4,5,6
- select page.number, street.number, street.name
- from
- street, page
- where
- ST_INTERSECTS(street.geom, page.geom)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement