t_a
col1, col2, col3
---------------------
01, 11/01 aaa
01, 11/02 adc
02, 11/03 ddd
03, 11/10 ggg
03, 11/13 hhh
03, 11/15 kkk
.
.
t_b
col1, col2, col3
-------------------------
01, 11/02 ccc
02, 11/05 fff
03, 11/20 ppp
.
.
쿼리결과
01, 11/01 aaa
01, 11/02 adc
01, 11/02 ccc
02, 11/03 ddd
02, 11/05 fff
03, 11/13 hhh
03, 11/20 ppp
03, 11/13 hhh
03, 11/15 kkk
03, 11/20 ppp
t_a, t_b의 조회 결과가 쿼리결과처럼 나오게 할려면 어떻해야죠?
|