|
ermjai84
Starting Member
4 Posts |
 Posted - 2008-07-11 : 02:37:22
|
| HiActuly I am Using Multiple Table at the same time i am using group by and used union function but i came the error is incorrect sentax keyword Union so what i do please help me GuysThis is my sample codingselect count(a.ackno) as macno,sum(a.amount) as ssmount,sum(a.netrevenue1) as netrevenue1,sum(a.netrevenue2) as netrevenue2,b.brname as brname ,a.empname1 as empname1,a.empname2 as empname2,a.amount1 as amount1,a.amount2 as amount2,c.prodgroup as prodgroup,a.passoutval as passoutvalfrom tranmast a,branmast b,prodmast c where a.brcode=b.brcode and a.prodcode=c.prodcode and a.brcode=any(select brcode from userright where empid='2222')and (a.chdddate between convert(datetime,'01/06/2008',103)and convert(datetime,'07/07/2008',103)) and a.transtatus='Complete' group by b.brname ,a.empname1,a.empname2 ,a.amount1,a.amount2,c.prodgroup ,a.passoutvalorder by c.prodgroup,a.empname1,a.empname2unionselect count(a.ackno) as macno,sum(a.amount) as ssmount,sum(a.netrevenue1) as netrevenue1,sum(a.netrevenue2) as netrevenue2,b.brname as brname ,a.empname1 as empname1,a.empname2 as empname2,a.amount1 as amount1,a.amount2 as amount2,c.prodgroup as prodgroup,a.passoutval as passoutvalfrom tranmast a , branmast b , prodmast c where a.brcode=b.brcode and a.prodcode=c.prodcode and a.brcode=any(select brcode from userright where empid='2222')and (a.trandate between convert(datetime,'01/06/2008',103)and convert(datetime,'07/07/2008',103)) and a.transtatus='Complete' group by b.brname ,a.empname1,a.empname2 ,a.amount1,a.amount2,c.prodgroup ,a.passoutvalorder by c.prodgroup,a.empname1,a.empname2Jayakumar |
|
Incorrect sentex unoin Keyword