A表中有字段code和desc
B表中有字段code
假如
A表: code desc
SA_001 CD_A
SA_002 CD_B
SA_003 CD_C
SA_004 CD_D
B表: code
SA_001,SA_002
SA_001,SA_002,SA_003,SA_004
SA_003
SA_004我最终想得到的查询结果是:
CD_A
CD_B
CD_A
CD_B
CD_C
CD_D
CD_C
CD_D
请教各位高手,应该怎么写。万分感谢!
B表中有字段code
假如
A表: code desc
SA_001 CD_A
SA_002 CD_B
SA_003 CD_C
SA_004 CD_D
B表: code
SA_001,SA_002
SA_001,SA_002,SA_003,SA_004
SA_003
SA_004我最终想得到的查询结果是:
CD_A
CD_B
CD_A
CD_B
CD_C
CD_D
CD_C
CD_D
请教各位高手,应该怎么写。万分感谢!
吗
这样不行,只能查询出来 SA_003和SA_004