Hi Pete. I’m using mySQL. It *is* a left join, but it assumes INNER and apparently what I wanted was OUTER. I need to read up on these to get an idea of what they are and why they are necessary. All my relational database experience in the past was using Foxpro, which is a somewhat different animal than SQL.
Bob S On May 15, 2015, at 11:53 , Peter Haworth <p...@lcsql.com<mailto:p...@lcsql.com>> wrote: 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 _______________________________________________ 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
