OK problem solved. Apparently SQL assumes inner join if not specified. If I define it as an OUTER join, I get all the device records as expected. Thanks for the help.
Bob S On May 15, 2015, at 11:07 , Peter Haworth <p...@lcsql.com<mailto:p...@lcsql.com>> wrote: Hi Bob, Something not right there. A LEFT JOIN should return all entries from the left table, presumably devices in your example, whether or not there are any matching entries in the other side of the join (accessories). _______________________________________________ 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
