One row with 2 same name columns

Question

I wish to have a resultset with 2 columns of data coming from the same column.

select cust,date,data 
from cust_a1 where ai_code between '17' and '19';

This will return multiple rows

1234567 | 04-04-2011 | special offer
1234567 | 04-04-2011 | cheep offer
1345678 | 04-04-2011 | friday offer
1345678 | 04-04-2011 | special offer

I would like to shape it like this:

1234567 | 04-04-2011 | special offer | cheep offer
1345678 | 04-04-2011 | special offer | friday offer

How can this be done?

How many times can an ID repeat is there any limit (like 1234567 repeats twice in the first dataset)? — Chandu, Apr 11 '11 at 14:58
Can you do this in code (PHP, c#, etc) or does this have to be done at the sql level? — RQDQ, Apr 11 '11 at 15:14
@Uw Concept - Usually I'd agree. Today I agree with asawyer. This is like helping a con man. — k to the z, Apr 11 '11 at 15:20

score 0 · Answer 1 · edited May 23 '17 at 11:47

0

This is usually known as a PIVOT

edited May 23 '17 at 11:47

Community

answered Apr 11 '11 at 15:23

Cade Roux

1 Answers1