Ok, I figured out how to join, but my code looks ugly. Now my question is how to optimize code below, because I use the same subquery twice (exec "webservice1".invokeHTTP(endpoint=>'2.0/api1',requestHeaders=> 'App-Key: key1',action=>'GET',requestContentType=>'application/xml')) SELECT &quo...

Hi all, I got some data returned by web api in json format. It is list of regions with timezone id. I can select regions and timezone id (the path is /root/regions) in one sql request. I can select timezone id with timezone description (the path is /root/timezones) in other sql request as well. The ...