¸ú×Ù£º
SELECT   djh000, xmbh00, xmmc00, xmgg00, xmdw00, xmdj00, xmsl00, hjje00,
         czrq00, shjg00, mxid00, xmbz00, (SELECT zwxm00
                                            FROM bm_ygbm00
                                           WHERE ygbh00 = a.kdys00) AS kdysxm,
         (SELECT bmmc00
            FROM bm_bmbm00
           WHERE bmbh00 = a.kdks00) AS kks000, zfbl00, tcje00
    FROM vw_mz_ghfymx a
   WHERE  ghid00 IN (
            SELECT ghid00
              FROM vw_yb_mzidfy
             WHERE brfb00 = 3
               AND czrq00 >= '20130119'
               AND czrq00 <= '20130119'
               AND yblb00 = '1'
               AND brid00 = 257759)
ORDER BY xmbz00, xmbh00, czrq00