On 03/30/2017 12:13 PM, David G. Johnston wrote:
> On Thu, Mar 30, 2017 at 11:03 AM, Gary Chambers <gwchamb(at)gwcmail(dot)com
> <mailto:gwchamb(at)gwcmail(dot)com>>wrote:
>
> Is there a better way to get the company information along with
> all of the
> addresses in a single query? This works, but it requires the
> additional
> step of splitting the addresses by the the delimiter at the
> application
> layer.
>
>
> To comment as to "better" without any knowledge of the "application
> layer" doesn't make sense.
>
> I suggest you provide an example of what you'd like the output to look
> like independent of any query concerns.
>
> David J.
>
If we assume the client layer is splitting by the pipe, why not just
send the set of addresses and the client simply iterates over that, no
hokey parsing involved.