<!--[if !mso]> <style> v\:* {behavior:url(#default#vml);} o\:* {behavior:url(#default#vml);} w\:* {behavior:url(#default#vml);} .shape {behavior:url(#default#vml);} </style>

SELECT stable.scate, stable.stname, s2table.aTime, atable.stname, a2table.aTime, available_reservation_seat AS ars, if( stable.scate = 'KTX', 7200 * count( 2table.no ) +8400, if( stable.scate = '새마을', 3136 * count( 2table.no ) +4800, 950 * count( 2table.no ) +2600 ) ) * rtable.ea as fee

FROM 1table AS stable

Inner Join rtable

on stable.stname = rtable.sStion

Inner join 2table AS s2table

on stable.no = s2table.t1no and s2table.aTime >= rtable.Time

Inner join 3table

on s2table.no = 3table.t2no

, 1table AS atable

Inner join rtable

on atable.stname = rtable.aStion

Inner join stable

on atable.scate = stable.scate

Inner join 2table AS a2table

on atable.no = a2table.t1no

Inner join s2table

on s2table.tno = a2table.tno

, 2table, 3table, rtable

WHERE

AND 2table.no > s2table.no

AND 2table.no < a2table.no

AND 3table.dynamic_date > ( rtable.date - curdate( ) )

Group by s2table.no