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> Pete lcSQL Software <http://www.lcsql.com> _______________________________________________ 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