>I have also tried the ff (all with same results):
>
>- using MySQL ODBC 5.1 instead 3.51.27
>- using the complete table names as field prefixes

How about adding the filter into the On clause instead of where ?
And checking with original table alias and unchanged field names ?

HTH

thomas