Union query

[mp3909]

I’m trying to do something like this:



select entity from t
where sector = ‘finance’
union
Select company from y

But I’m keep getting a input box saying enter parameter value for sector

[isladogs]

That suggests either that there is no sector field in 't' or that its not a text field.
Are both entity and company the same datatype?