I have 2 complex sql statements but they both have the same column name.
I am trying to do a union between both but the

```
    UNION

```

says Incorrect syntex near UNION. 

not sure if there is anything else necessary to make it work.