Query Designer Help
Hello!
I am trying to create a view using the Query Designer in Microsoft SQL Server Management Studio Express and do not know how to accomplish it. I need it based off of another view with columns CCNNumber & PartNumber.
For example I have these records...
09-0001 AO-1234
09-0001 MIO-5678
09-0001 SGO-9012
09-0002 MIO-1234
09-0002 MIO-9876
09-0003 ASO-1234
I want the view to generate the following....
09-0001 AO-1234; MIO-5678; SGO-9012
09-0002 MIO-1234; MIO-9876
09-0003 ASO-1234
(I am not very fluent with SQL...I am self taught and have not had any training.)
Any help would be greatly appreciated!
__________________
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
|
