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?