I need to build the capability of using aliases for names.
The idea is to have to tables: 1. NAMES; 2.ALIASES
There will be aliases for some of the names.
When a user wants to employ a name that is only known by
an alias, I want the system to first query NAMES and if there
is no result then to query ALIASES.
for the first step, how do I capture the result of the first query
( a SELECT) with the indication that the query produced no result ?