LEFT_JOIN_Sample.sql

    [良い例]
    SELECT A.NRJYUTYU,A.NRHINMOKU,B.TXHINBAN,B.TXHINMEI,A.QTJYUTYU
    FROM
      JTMS A
    LEFT JOIN HINMOKU B
      ON A.NRHINMOKU = B.NRHINMOKU
      AND 300 >= B.PRHANBAI --この条件は結合条件です
    
    [悪い例]
    SELECT A.NRJYUTYU,A.NRHINMOKU,B.TXHINBAN,B.TXHINMEI,A.QTJYUTYU
    FROM
      JTMS A
    LEFT JOIN HINMOKU B
      ON A.NRHINMOKU = B.NRHINMOKU
    WHERE
      300 >= B.PRHANBAI --結合条件を抽出条件に書いてはいけない