t1
Key INPUT_YMD INPUT_HMS
A 20140411 123601
A 20140411 123611
A 20140411 123621
B 20140411 123711
B 20140411 123721
C 20140411 122302
C 20140411 122312
C 20140411 122322
t2
Key FROM_YMD FROM_HMS TO_YMD TO_HMS
A 20140411 123601 20140411 123601
A 20140411 123603 20140411 123604
A 20140411 123622 20140411 123628
B 20140411 123712 20140411 123718
C 20140411 122302 20140411 122307
C 20140411 122323 20140411 122329
결과
KEY INPUT_YMD INPUT_HMS FROM_YMD FROM_HMS TO_YMD TO_HMS
A 20140411 123601 20140411 123601 20140411 123601
A 20140411 123601 20140411 123603 20140411 123604
A 20140411 123611
A 20140411 123621 20140411 123622 20140411 123628
B 20140411 123711 20140411 123712 20140411 123718
B 20140411 123721
C 20140411 122302 20140411 122302 20140411 122307
C 20140411 122312
C 20140411 122322 20140411 122323 20140411 122329
|