CREATE OR REPLACE VIEW SD_HOSPITAL.VW_SF_MXBJZXX
 (
 GHID00, GHRQ00, MXBMC0

 )
 AS 
select GHID00,  --¹ÒºÅID
       GHRQ00,   --¹ÒºÅÈÕÆÚ
       MXBMC0
 from (
select a.GHID00,
       a.GHRQ00,
       (select MXBMC0 from VW_SF_MXBZDXX where GHID00=a.GHID00 and rownum=1) MXBMC0 
from SF_BRXXB0 a
            ) where MXBMC0 is not null
/