I was trying to make a join between the table mentioned in the error with a hold file. I derive the hold file from a no of other tables.
Sample code:
Table file table1
print
----
where
---
on table hold as hold1
end
join col1 in hold1 to all
col1 in table2 as j1
end
join col1 and col2 in hold1 to all
col1 and col2 in table3 as j2]
end
The report works fine in the follwoing cases
i.e I dont get that error)
a. There are no records for the above join conditions
b. If 2nd join is not executed (i.e: in my code I will have a check to see if any column is needed from table3.If yes the I run that join else I dont.)
I am working on developer studio release 5.2.3
Hope I have clarified your doubt !!!