I have a query that will retrieve two columns of integer, They are the primary key. I will like to combine them into a unique name.
e.g. Key1 and Key2 are my keys
Select a.Key1, a.Key2, a.Key1+ '-'+a.Key2 from Mytable a
e.g. if key1 = 1010 and key2 = 2002 then the unique name I like to get is '1010-2002'
How do I do that?