SQL join question

[Peter Haworth]

That's strange since the SQLYoga stuff you posted specifies LEFT JOIN.
What flavor of SQL are you using?  Anyway, you got it working so all good.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Fri, May 15, 2015 at 11:20 AM, Bob Sneidar <bobsneidar at iotecdigital.com>
wrote:

> 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).
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>