An SQL query to return an UPDATE for the results?

[Peter Haworth]

On Sat, Aug 10, 2013 at 4:32 PM, Dr. Hawkins <dochawk at gmail.com> wrote:

> I'm only getting the results from the second query.  If done separately,
> I get multiple rows from the first query.
>

That's what I'd expect, the results of the second query ovewrite the
results of the first SELECT.  What you need is "SELECT <first selection>.
UNION SELECT <secondselection>

Pete
lcSQL Software <http://www.lcsql.com>