SQL Ver. 12 Joins

[AAVasaris]

I am making the transition from the XBase version to the SQL version and I have reports that I cannot duplicate. We are engineers and work on projects which have project data, timesheet data, expense data and hr employee name data in separate tables.____In the Xbase version I can join:____Jobdata to timedata using JOBNO (one-to-many)__Jobdata to expdata using JOBNO (one-to-many)__timedata to hrnames using EMPNO (one-to-one)____In the SQL version this gives the error "DB access: [Microsoft][ODBC Microsoft Access Driver] Join expression not supported" when using tables in a MS Access .mdb database as the data source.____The report also used the "SCAN" feature of the Xbase version to print:____General Job data (one record)__Time data (using scan) (multiple records) including names from hrnames__Expense data (using scan) (multiple records)____I^m confused. I like R&R Xbase very much, but the SQL version seems to be missing a lot of basics.____What are the workarounds, if any?______

[Stu_(Guest)]

Can you post the SQL on here?____We have a problem with R&R 12 creating invalid joins because of the non-standard SQL it generates.

[kfleming]

One workaround is to create a query in Access that performs the joins and then report in R&R against that query.____Kathleen__R&R Support