How to count total records from two different tables using UNION

[eluser]ram reddy[/eluser]
Hi to all ,


I am try to count total records from two different tabels , they have different values . like Table1- id , post_id, user_id, date Table2- id , Shared_id, user_id, date . If i call the query to count records , query result is 7 but 28 records in both tables.

How solue this problem;

Note : I am using UNION in Query to show recent updates in user profile