Skip to Content
0
Former Member
Jul 06, 2009 at 01:15 PM

Select from vertical to horizontal ??

293 Views

Hello Everybody

I use maxdb 7.6

I have a table "standardinfos" with default infos.(customer = 9911)

I have another table "customerinfos" with variable special infos.

The second table has columns fieldname,fieldvalue, linkkey

When doing a left join from standardinfos to customer infos i get a result with 1 to n rows (4 rows in the following example)

Now i need the records from table/cursor customerinfos in one record

Fieldname Fieldvalue Linkkey

F1 xyz 9911

F2 123 9911

F3 Blah 9911

F4 4711 9911

The wanted result should should look like:

F1 F2 F3 F4 linkkey

xyz 123 Blah 4711 9911

Is there an SQL command to get the wanted result ???

Any help welcomed

Best regards

Albert