Liveware Publishing Support Forum

I^m trying to do a Left Join in the RR SQL version using the standard MS Access ODBC driver.____I^m attempting a left join using the standard Join menu. When I choose the Left hand option and try to run the report, I get an error stating that my driver doesn^t support this manuever. Driver works fine for simple exact match join, but that^s not what I want.____Has anybody gotten around this limitation?

Create a view in Access that joins the tables and then use that view as the master table for your report.____Kathleen__R&R Support