DB01 SQL编辑器的一个例子

select  "/1MD/ZXZKUNNR",
            "/1MD/ZXBP_ID_NUM",
            "/1MD/ZXNAME_ORG1",
            "/1MD/ZXZZZLX",
            "/1MD/ZGZLIFNR",
            "/1MD/ZGBP_ID_NUM",
            "/1MD/ZGNAME_ORG1"
from "/1MD/MD______0A0"
inner join "/1MD/MD______09V"
on "/1MD/ZXBP_ID_NUM" = "/1MD/ZGBP_ID_NUM"
and "/1MD/ZXREF_POSTA" = "/1MD/ZGREF_POSTA"
and "/1MD/ZXBP_IDTYPE" = "/1MD/ZGBP_IDTYPE"
where "/1MD/ZXBP_ID_NUM" <> ''
and "/1MD/ZXXBLCK" <> 'X'
and "/1MD/ZGXBLCK" <> 'X'

union

select  "/1MD/ZXZKUNNR",
            "/1MD/ZXBP_ID_NUM",
            "/1MD/ZXNAME_ORG1",
         "/1MD/ZXZZZLX",
            "/1MD/ZGZLIFNR",
            "/1MD/ZGBP_ID_NUM",
            "/1MD/ZGNAME_ORG1"
from "/1MD/MD______0A0"
inner join "/1MD/MD______09V"
on "/1MD/ZXNAME_ORG1" = "/1MD/ZGNAME_ORG1"
and "/1MD/ZXREF_POSTA" = "/1MD/ZGREF_POSTA"
where "/1MD/ZXNAME_ORG1" <> ''
and "/1MD/ZXBP_ID_NUM" = ''
and "/1MD/ZXZZZLX" = '2'
and "/1MD/ZGZZZLX" = '2'
and "/1MD/ZXXBLCK" <> 'X'
and "/1MD/ZGXBLCK" <> 'X'