Readability Of Answer Tables

It is possible, and sometimes desirable, for mSQL to answer in sentences, rather that in table form. We can fake this by customising the select clause of the query, by adding descriptive littorals:

select artist,' recorded ',alb_name,' in ',p_date
from albums

results in an answer table with rows resembling:

band recorded album in date

As a courtesty to your user, littorals can make the difference between a cryptic answer table, and plain, easy to understand english.

You can use the "as" modifier in your select statements also:

select year(now())-pdate as age
from albums

effectively renames the answer table column, making it look nicer than the clumsy expression. This is more important in Access as it invents "Exp0001: " column headings which are ugly and confusing to users.