select log_user.*, location .name ;
  FROM log_user ;
    JOIN location ON location.code == log_user.location ;
  into cursor Tmp

>
>
>A field of a table (log_user) (VARCHAR(50)) is used to log the authorization level, e.g. TS,MT
>means the user can login for TS or MT shops.
>
>However, the real name should be TS = Tesco & MT = Maytower
>
>A Table called the location
>
>Code Name
>TS Tesco
>MT Maytower
>
>My question, how to select from the character field with the location table,
>
>

>select name from location where code = (log_user.location) into cursor Tmp
>