how to merge three diff columns in a single column in sql : I have three columns from diff tables 

         select  t1.Count_1,t2.Count_2,t3.Count_3 from 
    (SELECT count(*) as Count_1 FROM GuestAddressData) as t1, 
    (SELECT count(*) as Count_2 FROM GuestAddressData) as t2,
    (SELECT count(*) as Count_3 FROM SMSTable) as t3 

but now i want to get it like 

    1,1,1 as total 

