select 1 union select 2 go select 1 union select 1

select uu.customername ,profileid from ( select Upper(Name) as customername ,profileid,companyid,branch_id,agent_id from client union select upper(clientname) as customername ,clientid as profileid ,companyid,branchid as branch_id, agentid as agent_id from meetingClient ) as uu where uu.companyid='0003' and uu.branch_id=106 and uu.agent_id=3