CREATE CURSOR states ( st c(2) ) INSERT into states VALUE('KS') INSERT into states VALUE('MO') CREATE CURSOR widgets (st c(2), misc c(3)) INSERT INTO widgets values( 'KS', 'ABC') INSERT INTO widgets values( 'KS', 'DEF') INSERT INTO widgets values( 'KS', 'GHI') INSERT INTO widgets values( 'MO', 'ABC') I want to see the data as follows: St Widgets --- ----------- KS ABC|DEF|GHI MO ABC Can this be done in SQL?