JOIN without losing any rows except duplicates

I need to essentially stack one View from management studio onto another, but without any duplicates. I’ve looked at my options but have no idea with what is right. Help!

Without seeing a schema…I’ll ask if you have you looked into UNION ALL ? It doesn’t remove duplicates.

1 Like