Select Sum(Actions) From
(
Select
Count(Create_Dtime) As Actions
From Player_Tapjoy
Where
Trunc(Create_Dtime) = To_Date('2012-sep-12','yyyy-mon-dd')
Union All
Select
Count(Create_Dtime) As Actions
From Player_aux_pt
Where Site = 'AppCircle' And
Trunc(Create_Dtime) = To_Date('2012-sep-12','yyyy-mon-dd')
);

Select Player_Id From Player_Source S Inner Join Feature_Group_Xref F
On S.Group_Id=F.Group_Id
where f.feature_name = 'BC'

Select Sum(Actions) From
(
Select
Count(t.Create_Dtime) As Actions
From Player_Tapjoy t inner join player_source s on (t.player_id = s.player_id)
Inner Join Feature_Group_Xref F On (S.Group_Id=F.Group_Id and f.feature_name = 'BC')
Where Trunc(t.Create_Dtime) = To_Date('2012-sep-12','yyyy-mon-dd')
Union All
Select
Count(a.Create_Dtime) As Actions
From Player_aux_pt a inner join player_source s on (a.player_id = s.player_id)
Inner Join Feature_Group_Xref F On (S.Group_Id=F.Group_Id and f.feature_name = 'BC')
Where a.Site = 'AppCircle' And
Trunc(a.Create_Dtime) = To_Date('2012-sep-12','yyyy-mon-dd')
)