RR SQL multiple join limitation

[Philippe_(Guest)]

When In link my master table to a first relate table, the join allows "include unmatched records on left" option. When I create asecond join, it is no more possible to also choose "include unmatched records on left". This is really bad since I need several relations to translate a code from the master table in different ^lookup^ tables.__Did I do something wrong or is RR limited ?____Thank you____Philippe__

[kfleming]

What is allowed depends upon the driver.____Kathleen__R&R Support

[Philippe_(Guest)]

Could you indicate which efficient driver I should use to connect RR with Mysql Database ? __At the moment I^m using "MySQL ODBC 3.51 Driver" which seems to have the limitation described above.____Thank you____Philippe

[kfleming]

There may not currently be another driver available. I know that the folks at DataDirect have a MySQL driver in the works but I think that it is not slated to be available until early 2005.____Kathleen__R&R Support