A라는 테이블에
1번 게시물에
[필드11=2018-01-01, 필드12=100원,필드13=라면]
[필드14=2018-01-02, 필드15=200원, 필드16=밥]
[필드17=2018-01-03, 필드18=150원, 필드19=된장 ]
2번 게시물에
[필드11=2018-01-02, 필드12=120원, wr_13=국물]
[필드14=2018-01-03, 필드15=240원, wr_16=콩나물]
[필드17=2018-01-04, 필드18=170원, wr_19=고추장]
이렇게 등록되있을때
필드11,필드14,필드17을 합쳐서 최근 날자순으로 정렬하고 싶습니다
쿼리문 어떻게 써야하나여~?
Comment 1
-
엔더
2018.06.05 16:45
SELECT
S.V1, S.V2, S.V3
FROM (
SELECT 필드11 AS V1, 필드12 AS V2, 필드13 AS V3 FROM A UNION ALL
SELECT 필드14 AS V1, 필드15 AS V2, 필드16 AS V3 FROM A UNION ALL
SELECT 필드17 AS V1, 필드18 AS V2, 필드19 AS V3 FROM A
) S
ORDER BY S.V1 DESC . . .