On Sun, Aug 11, 2013 at 2:02 PM, Peter Haworth <p...@lcsql.com> wrote: > On Sat, Aug 10, 2013 at 4:32 PM, Dr. Hawkins <doch...@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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
