>Naomi,
>
>One more try - get rid of aliases completely (even if it will make it longer to write) and use table name as alias.
>
>Same outcome... {exasperated}
>
>Dennis

Have you tried creating a new CA class from scratch using the statement with table names spelled out? May be the previous CA got 'cursed'.

If this will not help, I think the problem may be in MySQL driver you used.