how to count group by data on two union table

[achikeziey]

select mobile ,count(id) from
(select  mobile ,id from phone_1204 where astatus='newsub' and left(service,4)='euro'
union all
select mobile,id from phone_1205 where astatus='newsub' and left(service,4)='euro' )
 group by mobile

are this the right code

[India777]

Try with @@ROWCOUNT.This Returns the number of Rows affected by the Sql Query.Please Study this link to know abount @@ROWCOUNT.
http://technet.microsoft.com/en-us/l.../ms187316.aspx and http://msdn.microsoft.com/en-us/library/ms188774.aspx.

Example:

select @@rowcount as count, mobile ,count(id) from
(select mobile ,id from phone_1204 where astatus='newsub' and left(service,4)='euro'
union all
select mobile,id from phone_1205 where astatus='newsub' and left(service,4)='euro' )
group by mobile
 

[Rabbit]

Please use code tags when posting code.

If you run it, you will know if it's correct or not.