Re: How to write this sql urgent...

Date: Mon, 25 Jan 2010 08:53:40 -0800 (PST)
Message-ID: <>

this is only a simple example, the proper data is very complex. So i couldn't provide the scripts.

from the result i wanted, you can find the pattern. It is to regernarate a full list of codes (5 codes) details with refs (1, 2, 3,.... 1000 from tab 1) Received on Mon Jan 25 2010 - 10:53:40 CST

Original text of this message