Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select from vertical to horizontal ??

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

Former Member
Not what you were looking for? View more on this topic or Ask a question