Left Join not working

[Ken_(Guest)]

Here is my problem. I have three tables, ARINVC (invoice header), ARITRS (invoice detail of line items), and the ICITEM (inventory item details). Master table is ARINVC that relates to the ARITRS. Then the ARITRS table relates to the ICITEM table. If there is no related ARITRS record, it disregards the ARINVC record. I need the data in the ARINVC table for my report. If I try to join the ARINVC table to the ARITRS table with a _left_ join, I get an error message. The join between the ARITRS and ICITEM is a left join that works without problem.______

[kfleming]

What ODBC driver are you using?____Kathleen__R&R Support

[Ken_(Guest)]

SQL Server. I am using v10 of R&R SQL.

[Ken_(Guest)]

Any direction?