SQL join question

Bob Sneidar bobsneidar at iotecdigital.com
Fri May 15 20:20:41 CEST 2015

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 <pete at lcsql.com<mailto:pete at 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).

More information about the use-livecode mailing list