Page 1 of 1
RR SQL multiple join limitation
Posted: Thu Sep 09, 2004 7:52 am
by 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__
=> RE: RR SQL multiple join limitation
Posted: Thu Sep 09, 2004 2:09 pm
by kfleming
What is allowed depends upon the driver.____Kathleen__R&R Support
==> RE: RR SQL multiple join limitation
Posted: Fri Sep 10, 2004 4:03 am
by 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
===> RE: RR SQL multiple join limitation
Posted: Fri Sep 10, 2004 6:57 am
by 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