>>select ctemp.custmer_id, state, potncust.name_full from ctemp, potncust ; >> where ctemp.custmer_id = potncust.custmer_id order by state, custmer_id into cursor ctemp1 >> >>select potncust.custmer_id, state, potncust.name_full from ctemp, potncust ; >> where ctemp.custmer_id = potncust.custmer_id order by state, custmer_id into cursor ctemp1 >>>>