Left Join not working
Posted: Tue Nov 08, 2005 12:59 pm
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.______