hell, I've seen code with UNIONs and inside
the UNION is a distinct clause! wtf?

(select distinct a from tableA)
union
(select distinct a from tableB)