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 <bobsnei...@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 <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 > _______________________________________________ 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
