The question needs a bit clarification. If the two tables are having the same structure and records are put on both tables you can use the union or union all operator that will put all the records from the two tables and then use the count function as count(*) or count(userid) that will give you the total number of abservation. The second option is as described by Donna join the tables and use the count function.
Alemayehu G. Desta
Leave a comment: