MS SQL a GROUP BY

[..::Ozzy::..]

select *from (
select neco as Smlouva from tabulka1
union 
select necoJineho as Smlouva from tabulka2
) all
group by all.Smlouva

neco a necoJineho musi bejt stejneho datoveho typu