PaulWyatt
Member
Hello
I have been using this for many years and yesterday I found something I didn't understand. So that my queries can run without amending dates each month, I introduced a new file with the dates in.
I joined the date in the primary file to two dates in the new date file (a from date, and a to date).
On 3 queries, the system didn't complain, and the results on the first two tested OK.
When I changed further queries the system started to tell me that I couldn't have multiple joins for the file ID.
I then discovered that the data retrieval for the 3rd query was wrong (too much data).
My questions are:
If your not allowed to join files in this way, why does query only report an error sometimes, and why are the results sometimes OK and sometimes not???
BTW for the join test, im using GE and LE for the two dates.
Any help would be appreciated
I have been using this for many years and yesterday I found something I didn't understand. So that my queries can run without amending dates each month, I introduced a new file with the dates in.
I joined the date in the primary file to two dates in the new date file (a from date, and a to date).
On 3 queries, the system didn't complain, and the results on the first two tested OK.
When I changed further queries the system started to tell me that I couldn't have multiple joins for the file ID.
I then discovered that the data retrieval for the 3rd query was wrong (too much data).
My questions are:
If your not allowed to join files in this way, why does query only report an error sometimes, and why are the results sometimes OK and sometimes not???
BTW for the join test, im using GE and LE for the two dates.
Any help would be appreciated