SQL join question

[Bob Sneidar]

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