On Thu, Mar 30, 2017 at 11:03 AM, Gary Chambers <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.