Essentially I have two sub-categories that I want to merge in a database. However I only want UNIQUE values, as some information in sub 1 is in sub 2. I want only unique information from sub 2 to be added to sub 1.

Any help with this query would be appreciated.

Language: mssql

and the database server would be?

Originally Posted by chrishirst

and the database server would be?

mssql

Does this help? http://support.microsoft.com/kb/139444

http://bytes.com/topic/sql-server/an...ows-inner-join