SQL question

From: <terry_stjean_at_my-deja.com>
Date: Mon, 14 Aug 2000 18:51:13 GMT
Message-ID: <8n9f2u$bpj$1_at_nnrp1.deja.com>

[Quoted] [Quoted] I have a table which contain 4 records per product. The 4 records represent the products hierarchy codes. A sequence number identifies the hierarchy level.
e.g. Product Level Code

      A       1     A2
      A       2     C4
      A       3     10
      A       4     01

Is it possible in SQL to reformat this to the following: Product Lvl1 Lvl2 Lvl3 Lvl4

   A A2 C4 10 01

Then I will join this onto our main sales file.

Terry

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 14 2000 - 20:51:13 CEST