HELP SQL GURUS

Hi,

     I have a simple join on two table to produce a/view or table    with the following rows.

        id   Desc
        88    a
        88    b
        88    c
        90    a
	90    b
        91    d

   Under time pressure I have to build a view to TRANSPOSE    the rows and colums like this

     id  desc1  desc2  desc3   ...   desc7
     88   a      b      c             NULL
     90   a      b      NULL          NULL
     91   d      NULL   NULL          NULL

   There is a maximum of only using seven columns.

Help please,
Thanks

Brian Spears Received on Thu Dec 12 1996 - 00:00:00 CET