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

Reply via email to