It's not clear from your post what the problem is. Did you try to use the same query but group on iTableID,company ?

>The query below is returning the data, but I need to group it on PrimaryCarrier/iTableID. Here is the output of the current query:
>
< snip >