개발자포럼 입니다.
한 컬럼을 쪼갰을때 공백문제(그림 첨부하였습니다.)14
- 김군패밀리
- 등록일 2013-08-22 10:19
- 조회수 336
|
||
0
추천하기
다른의견
0
|
파워링크 
등록안내
등록안내
![[* 비회원 *]](http://cdn2.ppomppu1.co.kr/zboard/nickcon/155047.gif?v=20241116)
|
 0
 0
봄-봄
약간 꽁수를 부렸습니다.
SELECT MAX(in_product_name) in_product_name, MAX(in_buyer_name) in_buyer_name, MAX(in_price) in_price, MAX(out_product_name) out_product_name, MAX(out_buyer_name) out_buyer_name, MAX(out_price) out_price FROM ( SELECT ROWNUM R, product_name in_product_name, buyer_name in_buyer_name, price in_price, \'\' out_product_name, \'\' out_buyer_name, \'\' out_price FROM dk_in_out a WHERE LEFT(a.regdate,10) = \'2013-08-13\' AND a.output_account =\'05\' AND in_out_type=\'in\' UNION ALL SELECT ROWNUM R, \'\' in_product_name, \'\' in_buyer_name, \'\' in_price, product_name out_product_name, buyer_name out_buyer_name, price out_price FROM dk_in_out a WHERE LEFT(a.regdate,10) = \'2013-08-13\' AND a.output_account =\'05\' AND in_out_type=\'out\' ) GROUP BY R |
|
|
0
1
봄-봄
이렇게도 가능해요. 이게 더 깔끔할거 같네요.
SELECT A.in_product_name in_product_name, A.in_buyer_name in_buyer_name, A.in_price in_price, B.out_product_name out_product_name, B.out_buyer_name out_buyer_name, B.out_price out_price FROM ( SELECT ROWNUM R, product_name in_product_name, buyer_name in_buyer_name, price in_price FROM dk_in_out a WHERE LEFT(a.regdate,10) = \'2013-08-13\' AND a.output_account =\'05\' AND in_out_type=\'in\' ) A, ( SELECT ROWNUM R, product_name out_product_name, buyer_name out_buyer_name, price out_price FROM dk_in_out a WHERE LEFT(a.regdate,10) = \'2013-08-13\' AND a.output_account =\'05\' AND in_out_type=\'out\' ) B WHERE A.R = B.R |
|
|
|
 |
|
| △ 이전글▽ 다음글 | 목록보기 |
|
정확한 결과 아웃풋을 작성하셔서라도 보여주셔야 답이 나올것 같은데요..