Posted by hlajeunessse on 07/03/07 20:53

Hi!

I have a table looking like

(username) (account number) (start date) (end date) (product)

wich I can have up to 4 lines for the same client.

I wist to transfert those lines into a new table looking like

(username) (account number) (start date 1) (end date 1) (product 1)
(start date 2) (end date 2) ... (product 4)

How (in SQL) I could do it?

• Next in forum: Re: How can I combine different rows?
• Prev in forum: Yellowfin Business Intelligence 3.2 released
• Thread view: How can I combine different rows?

[Reply to this message]