1
2
3
4
5
6
7
8
9
10
11
12
13
14

select subStr(safpf_buss_date,0,11) as subStr_buss_date,
       expsm8_id||expsm8_name as driverid, 
       safpf_route_no as route_no,
       safpf_bus_no as bus_no,
       psc5_service_rate as service_rate,
       psc5_type_name as type_name,
       sum(safpf_boarding_qty)as sum, 
       sum(safpf_boarding_qty)as amt,
       sum(safpf_boarding_qty)as people 
from expsm8 
inner join safpf on CAST(safpf_driver_no AS INTEGER)=CAST(expsm8_id AS INTEGER) 
inner join psc5 on psc5_card_type=safpf_card_type 
group by driverid,subStr_buss_date 
order by subStr_buss_date

1
2
3
4
5

select safpf_driver_no,safpf_card_type,expsm8_id,psc5_card_type
from expsm8 
inner join safpf on CAST(safpf_driver_no AS INTEGER)=CAST(expsm8_id AS INTEGER) 
inner join psc5 on psc5_card_type=safpf_card_type 
where safpf_route_no='2'