쿼리문좀 봐주세요... 정보
쿼리문좀 봐주세요...
본문
Table Name : sche
------------------------------------------
wr_id mb_id wr_link1 wr_link2
-------------------------------------------
1 usr 20081003 20081003
2 use 20081003 20081005
3 use 20081004 20081004
4 use 20081004 20081004
5 use 20081005 20081005
=============================================
wr_link1, wr_link2 날자입니다.....
Table Name : car
------------------------------
car_id mb_id car_1
------------------------------
1 usr 2008-10-04
2 use 2008-10-07
3 use 2008-10-10
==============================
car_1 날자형식입니다....
sche + car 요2개를 합쳐서 아래와 같은 결과를 뽑아야하거든요..;;
------------------------------------------
wr_id mb_id wr_link1 wr_link2
-------------------------------------------
1 usr 20081003 20081003
2 use 20081003 20081005
3 usr 20081004
4 use 20081004 20081004
5 use 20081004 20081004
6 use 20081005 20081005
7 use 20081007
8 use 20081010
=============================================
위처럼 결과가 나오면 되구요...
어떤분이 아래처럼 답변을 해주시더라구요.
================================
select rownum wr_id,mb_id,wr_link1,wr_link2 from dual,
(select mb_id,wr_link1,wr_link2 from sche union all
select mb_id,to_char(to_date(car_1,'YYYY-MM-DD'),'YYYYMMDD')wr_link1,''wr_link2 from car)
order by wr_link1 asc, wr_link2 asc
=====================================
rownum은 오라클에서만 사용하는거라고.. Mysql에서 사용하게끔 바꿔서
하면된다고만하시네요..
그래서 지식인 찾아봐서...
rownum 대신 @n:@n+1 as rownum 을 넣으면 된다고 하더라구요..;
그런데.. 저는 도대체... 이걸 어떻게 해야되는지를 모른다는거죠..
도와주세요..
댓글 전체
================================
select @n:@n+1 as wr_id,mb_id,wr_link1,wr_link2 from dual,
(select mb_id,wr_link1,wr_link2 from sche union all
select mb_id,to_char(to_date(car_1,'YYYY-MM-DD'),'YYYYMMDD')wr_link1,''wr_link2 from car)
order by wr_link1 asc, wr_link2 asc
=====================================
쿼리문이 재대로 나온다면.. 위와 같이 하시면 되는것 아닐까요??
select @n:@n+1 as wr_id,mb_id,wr_link1,wr_link2 from dual,
(select mb_id,wr_link1,wr_link2 from sche union all
select mb_id,to_char(to_date(car_1,'YYYY-MM-DD'),'YYYYMMDD')wr_link1,''wr_link2 from car)
order by wr_link1 asc, wr_link2 asc
=====================================
쿼리문이 재대로 나온다면.. 위와 같이 하시면 되는것 아닐까요??
요렇게..해서 해결했습니다.
SELECT mb_id, wr_link1 , wr_link2
FROM sche
UNION ALL
SELECT mb_id , date_format( car_1, '%Y%m%d' ) , ''
FROM car
ORDER BY wr_link1
SELECT mb_id, wr_link1 , wr_link2
FROM sche
UNION ALL
SELECT mb_id , date_format( car_1, '%Y%m%d' ) , ''
FROM car
ORDER BY wr_link1
