What I want to do is update column (Table A) by values from another table (Table B) using condition intersects. There are few objects in table B which intersects one object from table A. When I try to do this I get only one value to column (Table A), but these are not all. How to update column by all values from Table B?


| improve this question | | | | |
  • What exactly do you mean with "by all"? Show an example. – CL. Feb 7 '19 at 12:09
  • Something like that i.imgur.com/gwHWs2c.jpg – pan Feb 7 '19 at 19:16
  • The MapBasic SQL dialect does not have a function like group_concat() or string_agg(). Would it be possible to upload the data into a real database? – CL. Feb 7 '19 at 20:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.