17,382
社区成员
发帖
与我相关
我的任务
分享合并SQL语句
select fvolume,fcode, fname from tb_secpossession where fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-8','yyyy-mm-dd') and fvolume <> 0结果如下：
select * from tb_secpossession where fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-31','yyyy-mm-dd') and fcode ='002203'fcode为上表中每一个fcode。
如何合并成一条语句？
...全文
请发表友善的回复…
发表回复
dbcxbj 2008-07-10
- 打赏
- 举报
sorry，看走眼了
select * from tb_secpossession where fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-31','yyyy-mm-dd') and fcode in (select fcode from tb_secpossession where fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-8','yyyy-mm-dd') and fvolume <> 0)
select * from tb_secpossession where fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-31','yyyy-mm-dd') and fcode in (select fcode from tb_secpossession where fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-8','yyyy-mm-dd') and fvolume <> 0)
ws010 2008-07-10
- 打赏
- 举报
这逻辑明显不对嘛
dbcxbj 2008-07-10
- 打赏
- 举报
select 你要的字段 from tb_secpossession where (fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-8','yyyy-mm-dd') and fvolume <> 0) or (fsetid = 'SB0204' and ftype='GP' and fdate = to_date('2008-1-31','yyyy-mm-dd') and fcode ='002203')