Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dterry
Starting Member
2 Posts |
 Posted - 2005-12-20 : 14:49:39
|
| Hello Everyone,When it comes to grouping report data my SQL skill is lacking – here is what I am trying to achieve.I have one table called Catalogs: Catalogs CatID CatNameAnother table called SkuList: SkuList CatID SKU ActionI know that each catalog might have one or more of the same SKUs. What I would like to display is something like the following: CatName1 CatName2 CatName3SKU1 Action Action ActionSKU2 “” “” “”SKU3 “” “” “”What is the statement I need to write to display this data?Best regards,David T. |
|
|
dterry
Starting Member
2 Posts |
Posted - 2005-12-20 : 14:52:13
|
| Correction...I know that each catalog might have one or more of the same SKUs with different action codes. |
 |
|
|
|
|
|
Grouping Help