Re: How to write this sql urgent...
From: JIACHENG SUN <sunjcb_at_googlemail.com>
Date: Mon, 25 Jan 2010 08:53:40 -0800 (PST)
Message-ID: <db7a5d34-7a47-490f-97f9-f46f46e580d3_at_k35g2000yqb.googlegroups.com>
this is only a simple example, the proper data is very complex. So i couldn't provide the scripts.
Date: Mon, 25 Jan 2010 08:53:40 -0800 (PST)
Message-ID: <db7a5d34-7a47-490f-97f9-f46f46e580d3_at_k35g2000yqb.googlegroups.com>
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