SQL : combine 2 rows into 1

Question

This is my database

I'm trying to display "hello" and "wo" in the same column

My SQL statement:

SELECT 
    d.CampaignId, d.ClientID, 
    citn.ImagePath AS Thumbnail, cidi.ImagePath AS DetailImage
FROM  
    MasterData.CampaignImage AS d 
INNER JOIN
    MasterData.CampaignImage AS citn ON d.CampaignId = citn.CampaignId  
                                     AND d.ClientID = citn.ClientID 
                                     AND citn.ImageTypeId = 1 
INNER JOIN
    MasterData.CampaignImage AS cidi ON d.CampaignId = cidi.CampaignId 
                                     AND d.ClientID = cidi.ClientID 
                                     AND cidi.ImageTypeId = 2

The output:

But now I have 2 rows in my output, how can I combine these into just one row?

Answer 1

Simply do SELECT DISTINCT to skip duplicate rows.