we have two tables: table1 and table2.
table1:-
id
tb1234
tb1236
table-2
tb1238
i want display only total distinct recrords count only(tablae 1 and table 2) like 3
iam using below query displays like 4
select sum(tbl.AllCount) From ( select count(DISTINCT id) as AllCount from Table_1 UNION ALL select count(DISTINCT id) as AllCount from Table_2 )tbl
plz help me