I struggled with this same problem, and though I still didn't figure it out completely I can tell you this :

a. the generate SQL command meets the rules of standard SQL.

b. the view designer generates an error on the SQL command it generates but the SQL command executes correctly ; try to copy and paste it in the command window : it will work. The viewdesigner refuses to save this view, and I still didn't find out how to force it.

c. the work around I use for now (hoping to find a better solution one day, maybe with this thread), is to put the second joincondition (which one doesn't matter) in the where clause.