CREATE TABLE #t (a int NOT NULL, b VARCHAR(10), c VARCHAR(10))
INSERT #t (a, b,c) VALUES (1, 'ab', 'cd')
INSERT #t (a, b,c) VALUES (1, 'ef', 'gh')
INSERT #t (a, b,c) VALUES (2, 'ij', 'kl')
INSERT #t (a, b,c) VALUES (2, 'mn', 'op')
a concatstringb concatstringc
1 'abef' 'cdgh'
2 'ijmn' 'klop'
My query is not working. Kindly help.
from tab inner join