[vox-tech] SQL help - unions

[Rod Roark]

On Wednesday 21 July 2004 05:00 am, Peter Jay Salzman wrote:
...
> The downside of using Access (other than the obvious) is that you tend
> to rely on the GUI interface when you should be concentrating on your
> basic SQL skills to prepare yourself for the inevitable time when you
> HAVE to use SQL because the GUI can't do it (like now - there's no GUI
> for unions).

Well... one of the best things about SQL is the power of
the language.  If you try to distance yourself from its
complexity (e.g. with a GUI) you can really miss out on
opportunities to save yourself from writing and debugging
tons of (non-SQL) code.

Email me privately if you're interested in a recent example.

-- Rod