SQL join question

[Bob Sneidar]

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).