这条语句怎么转换？？oracle到SQL

[IORILI]

Select d.branch_name As syb_name,
Sum(b.receieve_amount)
From sp_bol a,
sp_bol_detail b,
sp_carry c,
cd_branch d,
cd_tran_net e,
sp_order f
Where a.row_id = b.bol_id
And a.row_id = c.refer_id
And a.branch_id = d.row_id
And a.branch_id = e.branch_id
And c.supt_branch_id = e.branch_id_tr
And b.order_id = f.row_id
And d.scode_branch_type = 'SYB'
And b.active_flag = '1'
And c.active_flag = '1'
And a.bol_status In ('2','9')
And ((f.Order_Type = 'CSO' And trunc(c.connect_date+e.air_period)=to_date('25-04-2005','dd-mm-yyyy')) Or
(f.order_type = 'LACK' And trunc(c.connect_date+e.tran_period)=to_date('25-04-2005','dd-mm-yyyy')) Or
(f.order_type = 'NORMAL' And trunc(c.connect_date+e.car_period)=to_date('25-04-2005','dd-mm-yyyy')))
And a.created_date > to_date('25-04-2005 17:00:00', 'dd-mm-yyyy hh24:mi:ss') - 7
And a.created_date < to_date('25-04-2005 17:00:00', 'dd-mm-yyyy hh24:mi:ss')
Group By d.branch_name

[IORILI]

看样子是没人会了

[tdtjjiao]

晕倒。
你还不如说你想到做什么，
把你的数据结构例出来
还是你想要的结果，帮你重新做那，
这个看的我直晕。

[siwuge]

Select d.branch_name As syb_name,
Sum(b.receieve_amount)
From sp_bol a,
sp_bol_detail b,
sp_carry c,
cd_branch d,
cd_tran_net e,
sp_order f
Where a.row_id = b.bol_id
And a.row_id = c.refer_id
And a.branch_id = d.row_id
And a.branch_id = e.branch_id
And c.supt_branch_id = e.branch_id_tr
And b.order_id = f.row_id
And d.scode_branch_type = 'SYB'
And b.active_flag = '1'
And c.active_flag = '1'
And a.bol_status In ('2','9')
And ((f.Order_Type = 'CSO' And trunc(c.connect_date+e.air_period)=to_date('25-04-2005','dd-mm-yyyy')) Or
(f.order_type = 'LACK' And trunc(c.connect_date+e.tran_period)=to_date('25-04-2005','dd-mm-yyyy')) Or
(f.order_type = 'NORMAL' And trunc(c.connect_date+e.car_period)=to_date('25-04-2005','dd-mm-yyyy')))
And a.created_date > to_date('25-04-2005 17:00:00', 'dd-mm-yyyy hh24:mi:ss') - 7
And a.created_date < to_date('25-04-2005 17:00:00', 'dd-mm-yyyy hh24:mi:ss')
Group By d.branch_name

SQL中的datetime不用加to_char，你直接用 date between '25-04-2005 17:00:00' and '26-04-2005 17:00:00' 日期格式要改成能用的，有可能是'2005-04-25 17:00:00'或者用format(date,'dd-MM-yyyy hh24:mm:ss')

[IORILI]

顶