CODEWITHSUNDEEP
sqlsql-server
user1824963
user1824963

Reputation: 101

Combine 2 records as one

I am trying to combine 2 records as one, I have seen some similar questions but these seem to be not a specific record in the DB

 SELECT Summary1 as a, Summary2 as b, Summary3 as c, DateUpdated as d
FROM  tbl_EC where id=1

SELECT Summary1 as e, Summary2 as f, Summary3 as g, DateUpdated as h
FROM  tbl_EC where id=2

Upvotes: 0

Views: 43

Answers (1)

jarlh
jarlh

Reputation: 44766

Do a self join:

SELECT t1.Summary1 as a, t1.Summary2 as b, t1.Summary3 as c, t1.DateUpdated as d,
       t2.Summary1 as e, t2.Summary2 as f, t2.Summary3 as g, t2.DateUpdated as h
FROM  tbl_EC t1
    JOIN tbl_EC t2 ON t1.id + 1 = t2.id
WHERE t1.ID = 1

Perhaps you want to switch to FULL OUTER JOIN, if any id may be missing?

SELECT t1.Summary1 as a, t1.Summary2 as b, t1.Summary3 as c, t1.DateUpdated as d,
       t2.Summary1 as e, t2.Summary2 as f, t2.Summary3 as g, t2.DateUpdated as h
FROM  tbl_EC t1
    FULL OUTER JOIN tbl_EC t2 ON t1.id + 1 = t2.id
                             and (t1.id % 2 = 1 or t2.id % 2 = 0)

Upvotes: 1

Related Questions