Gday all,
I've just been browsing this forum but cvan't find the appropriate answer.
I need a view to combine multiple rows into a single row.
My table is thus:
Key Field
1 AAA
1 BBB
2 CCC
2 AAA
3 BBB
3 AAA
4 DDD
4 CCC
and need it to display
1 AAA BBB
2 CCC AAA
3 BBB AAA
4 DDD CCC
It needs to be a view.
cheers
Danny
I've just been browsing this forum but cvan't find the appropriate answer.
I need a view to combine multiple rows into a single row.
My table is thus:
Key Field
1 AAA
1 BBB
2 CCC
2 AAA
3 BBB
3 AAA
4 DDD
4 CCC
and need it to display
1 AAA BBB
2 CCC AAA
3 BBB AAA
4 DDD CCC
It needs to be a view.
cheers
Danny