I got a situation where I needed sum of two independent table counts, had too search and got a querry as below.
Select count1 + count2 as total from
(Select count(*) as count1 from TABLE1 an where ....),
(Select count(*) as count2 from TABLE2 atf where ....)
Select count1 + count2 as total from
(Select count(*) as count1 from TABLE1 an where ....),
(Select count(*) as count2 from TABLE2 atf where ....)
No comments:
Post a Comment