join support is quite unoptimized. in fact sql2 is quite unoptimized. we have a 
layer in our system that automatically checks if the query can be rewritten to 
an sql1 statement for this reason.

regards
Lukas

Reply via email to