语句
select t1.scrq,substr(T2.CNAME,0,instr(T2.CNAME,'注')-1) 站名,T1.BBH,T1.RBCKSL,T1.RYDL,T1.BCKYL,T1.GXYL
from dmba01 T1,SJZD T2 where TO_CHAR(SCRQ,'YYYYMMDD')='20100504' AND T1.ZM='ZS01' AND T1.ZM=T2.DM
结果为
2010-5-4 杏十五一 1
2010-5-4 杏十五一 2 7586 38520 14.20 14.10
2010-5-4 杏十五一 3
2010-5-4 杏十五一 4
想得到结果
2# 1# 3# 4# 2010-05-04 杏十五一 7586 38520 14.20 14.10
就是把除了scrq、CNAME、BBH不空的记录中BBH（3个）合并成一个字段查出来
请问怎么写语句
create table DMBA01
(
CM VARCHAR2(10) not null,
KM VARCHAR2(10) not null,
ZM VARCHAR2(10) not null,
SCRQ DATE not null,
BGG VARCHAR2(2) not null,
BBH VARCHAR2(2) not null,
LSSZLX VARCHAR2(1) not null,
BCKYL NUMBER(4,2),
BRKYL NUMBER(4,2),
GXYL NUMBER(4,2),
BGYC NUMBER(4,2),
LL NUMBER(4,1),
DL NUMBER(4),
DY NUMBER(5),
GLYS NUMBER(3,2),
JKSW NUMBER(4,2),
CKSW NUMBER(4,2),
WC NUMBER(4,2),
RBCKSL NUMBER(7),
RYDL NUMBER(7),
DJXL NUMBER(5,2),
YXSS NUMBER(6,2),
BX NUMBER(5,2),
BSDH NUMBER(6,4),
LJYXSS NUMBER(9,2),
RYX
