An SQL query to return an UPDATE for the results?

Dr. Hawkins dochawk at gmail.com
Sun Aug 18 18:29:45 EDT 2013


On Sun, Aug 11, 2013 at 2:02 PM, Peter Haworth <pete at lcsql.com> wrote:
> 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>

Thank you.

And I'll need to add a cup of cleverness to align the field types for
the first few entries of the table with far fewer columns (after that,
I can just select a bunch of NULL. . . )

-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462




More information about the use-livecode mailing list