'아우터조인' 태그의 글 목록

'아우터조인'에 해당되는 글 1건

2010.04.28 [Oracle] 조인비교

[Oracle] 조인비교

DB 2010. 4. 28. 10:58

  SELECT                /*[COLLECTIONDAO.XML][COLLECTION.GETGDSLIST][20100329]*/
           TPDG.PLN_DISP_CLS_SEQ AS PLNDISPCLSSEQ, TPDG.PRIR AS GDSPRIR,
           TG.GDS_CD AS GDSCD, TG.GDS_NM AS GDSNM, TG.SALE_PRC AS SALEPRC,
           TSG.SHOP_GDS_CD AS SHOPGDSCD, TSG.DC_AMT AS DCAMT
      FROM TBL_PLN_DISP_GDS TPDG JOIN TBL_GDS TG ON TPDG.GDS_NO = TG.GDS_CD
           LEFT OUTER JOIN TBL_SHOP_GDS TSG ON TG.GDS_CD = TSG.GDS_CD
     WHERE TPDG.PLN_DISP_CLS_SEQ = #seq#
  ORDER BY TPDG.PRIR

SELECT                /*[COLLECTIONDAO.XML][COLLECTION.GETGDSLIST][20100329]*/
         TPDG.PLN_DISP_CLS_SEQ AS PLNDISPCLSSEQ, TPDG.PRIR AS GDSPRIR,
         TG.GDS_CD AS GDSCD, TG.GDS_NM AS GDSNM, TG.SALE_PRC AS SALEPRC,
         TSG.SHOP_GDS_CD AS SHOPGDSCD, TSG.DC_AMT AS DCAMT
    FROM TBL_PLN_DISP_GDS TPDG JOIN TBL_GDS TG ON TPDG.GDS_NO = TG.GDS_CD
         JOIN TBL_SHOP_GDS TSG ON TG.GDS_CD = TSG.GDS_CD
   WHERE TPDG.PLN_DISP_CLS_SEQ = #seq#
ORDER BY TPDG.PRIR