取用户帐号描述

来源:互联网 发布:编程怎么取后面的数 编辑:程序博客网 时间:2024/05/21 10:00
 

 DATA: NAME_FIRST LIKE ADRP-NAME_FIRST,
        NAME_LAST  LIKE ADRP-NAME_LAST.

  SELECT SINGLE

                  ADRP~NAME_FIRST
                  ADRP~NAME_LAST
     FROM ADRP

    INNER JOIN USR21 ON ADRP~PERSNUMBER =  USR21~PERSNUMBER
    INTO (NAME_FIRST,NAME_LAST)
  WHERE  USR21~BNAME = USERID.