这样的查询怎么样写

Question

a表
id
224
2423
434
5412
6532b表
id   idlist
1    224,123,2423,23
2    24,6532
3    5412,434a表的字段id在b表idlist有的,查出来.

Answer 1

SQL> select a1,a2 from a;A1         A2
---------- ----------
0101       aaa
0201       bbbExecuted in 0.016 secondsSQL> select b1,b2 from b;B1         B2
---------- ----------
01         
03         first
02         GoodExecuted in 0.016 secondsSQL> select distinct b1,b2 from a inner join b on instr(a1,b1)>0;B1         B2
---------- ----------
01         
02         GoodExecuted in 0.016 secondsSQL>

Answer 2

SQL> select * from AAA_CSDN_1;        ID
----------
       224
      2423
       434
      5412
      6532已用时间:  00: 00: 00.00SQL> SELECT * FROM AAAA_CSDN_2;        ID IDLIST
-----------------------------------------
         1 224,123,2423,23         2 24,6532         3 5412,434
已用时间:  00: 00: 00.10SQL> SELECT A.*
  2  FROM AAA_CSDN_1 A, AAAA_CSDN_2 B
  3  WHERE INSTR(B.IDLIST || ',', TO_CHAR(A.ID) || ',') > 0;        ID
----------
       224
      2423
      6532
       434
      5412已用时间:  00: 00: 00.20
楼主看这样行不行