|
-
May 27th, 2008, 05:10 AM
#1
Thread Starter
Lively Member
how to SQL Script
hi,
i have this table
TEST_CODE | MASTNO
2ELEM | 1
2V/LS | 1
3ELEM | 1
4ELEM | 1
5ELEM |2
6ELEM |2
7ELEM |2
8ELEM | 2
ACCUL | 2
ACTV. | 3
ADDT | 3
AFB | 4
AG/RA | 4
AIDS | 4
AIDS2 | 4
is there a way to have a result set from sql to have a
select <dddd> from table
<dddd> = "2ELEM,2V/LS,3ELEM,4ELEM"
so on and so fort
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|