Well, it's not hanging now, but i'm not getting the same number of values returned. In my example, this query:
select fromzone,tozone,scale from carrierscl where carrierid='FA' order by fromzone,tozone
returns this:
carrierid fromzone tozone scale
--------- -------- ------ -----
FA...