multiple counts each using a join of 2 tables union all another count that also joins two tables

Question

have 4 tables..1,2,3,4..need to

join tables 1 & 2

union all

join tables 3 & 4

return just one count from the union

Answer 1

Providing sample tables and data and the result you would want from that sample data would make your question more clear, but something like

;With cte
 As
(Select <column list>
From Table1
Inner Join Table2 On <join condition>
Union All
Select <column list>
From Table3
Inner Join Table4 On <join condition>)
Select Count(*) From cte;