another way
select t.name sum(t.count) From ( Write your first qry1 union Write your second qry2 ) as t *Group By t.name* Regards Prince On Friday, July 5, 2013 12:26:48 PM UTC+5:30, Prince wrote: > > > select t.name sum(t.count) > > From > ( > > Select * from qry1 > > union > > select * from qry2 > ) as t > > *Group By t.name* > > > > > Regards > Prince > > On Friday, July 5, 2013 12:25:30 PM UTC+5:30, Prince wrote: >> >> Just do this >> >> >> select t.name sum(t.count) >> >> From >> ( >> >> Select * from qry1 >> >> union >> >> select * from qry2 >> ) as t >> >> >> Regards >> Prince >> >> On Friday, July 5, 2013 12:02:00 PM UTC+5:30, rk sharma wrote: >>> >>> Dear Experts >>> >>> >>> i have two queries in acess 2010 screen shot attached which have data >>> mention below >>> >>> i just want to sum both of two queries. pl help >>> >>> query 1 query 2 >>> >>> >>> name count name count >>> >>> >>> rakesh 1 rakesh 9 >>> >>> mukesh 3 Mohit 2 >>> >>> pooja 9 raman 6 >>> >>> mohit 10 >>> >>> raman 3 >>> >>> >>> requirement >>> >>> sum of both queries. >>> >>> Name count >>> rakesh 10 >>> Mukesh 3 >>> Pooja 9 >>> Mohit 12 >>> Raman 9 >>> >>> Thanks in advance...!!! >>> >>> * * >>> RAKESH SHARMA >>> NPI –Team >>> Ericsson India Pvt. Ltd. >>> 4th Floor, Gupta Towers, Commercial Block, Rail Head >>> Jammu & Kashmir, INDIA >>> Phone 01912477440/ 01912477473/441 >>> Fax 01912477442 >>> Mobile +91 9906115140 >>> rakesh.kum...@ericsson.com >>> www.ericsson.com >>> >>> “If You fall, fall like a seed to germinate, not like a leaf to die.” >>> >>> -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
