CREATE TABLE tblB( odr INT, prod INT, isIncuded CHAR(1) );

너무 감사합니다~~~~

WITH code_t AS
(
SELECT 'A001' cd
UNION ALL SELECT 'A002'
UNION ALL SELECT 'A003'
UNION ALL SELECT 'A004'
UNION ALL SELECT 'A005'
UNION ALL SELECT 'A006'
UNION ALL SELECT 'A007'
UNION ALL SELECT 'A008'
-- 중략 --
UNION ALL SELECT 'A020'
)
, data_t AS
(
SELECT 'B001' no, 'A001' cd
UNION ALL SELECT 'B002', 'A021'
UNION ALL SELECT 'B003', 'A005'
UNION ALL SELECT 'B003', 'A008'
UNION ALL SELECT 'B004', 'A001'
UNION ALL SELECT 'B004', 'A100'
)
SELECT a.no
     , a.cd
     , CASE WHEN b.cd IS NOT NULL THEN 'Y' ELSE 'N' END cd_yn
     , MIN(CASE WHEN b.cd IS NOT NULL THEN 'Y' ELSE 'N' END)
       OVER(PARTITION BY no) no_cd_yn
  FROM data_t a
  LEFT OUTER JOIN code_t b
    ON a.cd = b.cd
;