Is it possible to create a join using a 'between' operator?
I had the following...
But that seemed to error, so I did a bit of Googling and found suggestions to change it to a range, so I tried this....
But that is erroring as the other syntax with
Does this mean it is a limitation of the JET driver and if I created a stored procedure in SQL it would be fine?
Or have I got the syntax wrong?
Thanks,
1DMF
"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
MIME::Lite TLS Email Encryption - Perl v0.02 beta
I had the following...
Code:
SELECT SUM(Rating) / COUNT(Rating) AS iCnt, Val FROM Compliance_Audit INNER JOIN RAG_Rating ON (iCnt BETWEEN MinAvg AND MaxAvg)
But that seemed to error, so I did a bit of Googling and found suggestions to change it to a range, so I tried this....
Code:
SELECT SUM(Rating) / COUNT(Rating) AS iCnt, Val FROM Compliance_Audit INNER JOIN RAG_Rating ON (iCnt >= MinAvg AND iCnt <= MaxAvg)
But that is erroring as the other syntax with
join expression not supported.
Does this mean it is a limitation of the JET driver and if I created a stored procedure in SQL it would be fine?
Or have I got the syntax wrong?
Thanks,
1DMF
"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
MIME::Lite TLS Email Encryption - Perl v0.02 beta