EOF generates incorrect SQL for Outer join on MySQL WO 5.1.3
"Eric Bergerson" <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.eof |
|---|---|
| Message-ID | <[email protected]> |
I am using WO5.1.3 on a PC running MySql version 3.23.51-max-nt. I have a model that requires a toMany outer join. EOF generates a query for the outer join in this form: select <attributes> from A, B where A.name = "eric" and A.id *= B.aId; However, MySql requires this type of query in this form: select <attributes> from A LEFT JOIN B on A.id = B.aId WHERE A.name = "eric" Does anyone know if there is anything that can be done to get EOF to generate the proper SQL? BTW, MySql claims to be SQL92 compatable. Is the SQL generated by WO SQL92 compatable? Sincerely, Eric Bergerson Contact Info: http://www.ukibi.com/eb