- - Select - - View all SELECT client_infoen.clientname_short, client_info.code FROM client_infoen, client_info where client_info.status='A' and client_infoen.clientid in (select clientid from function1 where function1.status='Y') and client_infoen.clientid = client_info.clientid order by clientname_shortPACIFIC ANDES (01174)