[sqlite] Degrouping, desummarizing or integrating headings

[T&B]

Hi All,

I come across a fair bit of source data in summary format, where the  
one field's values are used as a heading for a group of records for  
which it applies. For instance, this shopping list:

Aisle       Product      Cost
Dairy
            Milk         $2
            Cream        $1
            Cheese       $3
Bakery
            Sliced       $4
            Rolls        $3
            Cake         $2

How can I select the data from that table of 8 records so that the  
result is this table of 6 records?:

Aisle       Product      Cost
Dairy       Milk         $2
Dairy       Cream        $1
Dairy       Cheese       $3
Bakery      Sliced       $4
Bakery      Rolls        $3
Bakery      Cake         $2

Thanks,
Tom


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------