Hi Guys,
Need help with a query... I think pivot table is the way to go but don't wanna to use it as it is not supported in Oracle 10g.
Sample data set...
| Part | Section |
| A001 | AC |
| A001 | AY |
| A001 | AN |
| A001 | AX |
| A015 | AC |
| A015 | AR |
| A007 | AC |
| A008 | AN |
| A008 | AX |
| A008 | AE |
| A008 | AT |
| A008 | AY |
Required output... (Please note that I cannot hard code the Section column as the data is dynamic)
| Part | AC | AY | AN | AX | AR | AE | AT |
| A001 | Y | Y | Y | Y | | | |
| A015 | Y | | | | Y | | |
| A007 | Y | | | | | | |
| A008 | | Y | Y | Y | | Y | Y |
Can you help me out with this without using pivot tables?
Thanks,
Napster