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