As mentioned earlier, a LOV is the result of the execution of a SQL Statement. Any SQL statement can be executed to retrieve a LOV !!! That means that you can make joins, restrictions and whatever you want to retrieve your list of values.

In our example you can choose between a basic SQL statement (returning the list of countries) and a more complex one with a join (we want to add the the region name to the returned fields) and a restriction (we return only the countries located in America (north or south)).

The table bellow the SQL statements displays the results of the execution of the SQL. You can note the apparition of the region name when selecting the second statement. In a detail screen, this field could be displayed, for example, in a tooltip or in non editable LovField as an additional information to the user.