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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.