<!--[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 *

FROM 3table

LEFT JOIN 2table AS 2table1 ON ( 3table.t2no = 2table1.no )

LEFT JOIN 1table AS 1table1 ON ( 2table1.t1no = 1table1.no )

, rtable

where (rtable.sStion = 1table1.stname or rtable.aStion = 1table1.stname) and rtable.time<= 2table1.atime

group by 2table1.aTime



ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ


개짧아짐ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ