Oracle <-> Mysql Query
DB/MySQL
2009. 1. 28. 19:38
반응형
[오라클]
SELECT
DECODE (B.CASH, NULL, A.REGDATE, B.REGDATE) AS AA,
DECODE (B.CASH, NULL, A.POINT_CONTENT, B.CASH_CONTENT),
A.POINT_TYPE,
NVL(A.POINT,0),
B.CASH_TYPE,
NVL(B.CASH,0)
FROM A_TBL A FULL OUTER JOIN B_TBL B
ON A.POINT_O_CODE = B.CASH_O_CODE
ORDER BY AA
[mysql]
SELECT
AA ( case B.CASH NULL then A.REGDATE else B.REGDATE) ,
(case B.CASH NULL then A.POINT_CONTENT else B.CASH_CONTENT),
A.POINT_TYPE,
IFNULL(A.POINT,0),
B.CASH_TYPE,
IFNULL(B.CASH,0)
FROM my_point_tbl A FULL OUTER JOIN my_cash_tbl B
ON A.POINT_O_CODE = B.CASH_O_CODE
ORDER BY AA
SELECT
DECODE (B.CASH, NULL, A.REGDATE, B.REGDATE) AS AA,
DECODE (B.CASH, NULL, A.POINT_CONTENT, B.CASH_CONTENT),
A.POINT_TYPE,
NVL(A.POINT,0),
B.CASH_TYPE,
NVL(B.CASH,0)
FROM A_TBL A FULL OUTER JOIN B_TBL B
ON A.POINT_O_CODE = B.CASH_O_CODE
ORDER BY AA
[mysql]
SELECT
AA ( case B.CASH NULL then A.REGDATE else B.REGDATE) ,
(case B.CASH NULL then A.POINT_CONTENT else B.CASH_CONTENT),
A.POINT_TYPE,
IFNULL(A.POINT,0),
B.CASH_TYPE,
IFNULL(B.CASH,0)
FROM my_point_tbl A FULL OUTER JOIN my_cash_tbl B
ON A.POINT_O_CODE = B.CASH_O_CODE
ORDER BY AA
반응형