IT’S JUST AN EXAMPALE PUT YOUR DATA IN THIS CODE, HOPEFULLY THIS WILL WORK.
SELECT buy.CODE, buy.SIMPLE_COST_BASE, notsell.NORMAL_COST_BASE
FROM
(
(SELECT CODE, SUM(Costs)/SUM(Quantity) AS SIMPLE_COST_BASE
FROM Shares
WHERE EVENT = 'Buy'
GROUP BY CODE) AS buy
INN
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
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 * f
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
>
