Union Query not showing any results

Miker · September 28, 2020, 4:27pm

I am having issues getting any results out of a union query.

Miker · September 28, 2020, 4:32pm

I get 0 rows return and both queries return data.

Both as Top Level

Not sure what is going on…

Nancy_Hoyt · September 28, 2020, 5:10pm

Hi Mike,

Any chance the nvarchar and the x(50) on the Key is causing the problem bringing them together? Maybe make the nvarchar one a string with 50 char and then put it together? Just a thought…

Nancy

Miker · September 28, 2020, 6:05pm

You my friend are a savior. I matched the nvarchar character widths and it worked THANKS!

Nancy_Hoyt · September 28, 2020, 6:46pm

Great ~ you’re welcome!
I’ve seen that sort of fussiness with the union queries before …

Nancy