Select  carrier.CarrierName INSNAME ,  insplan.SubscriberID INSID from insplan  join carrier 
on insplan.carriernum = carrier.carriernum
where subscriber = <@PATNUM@>