>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.
If it's not broken, fix it until it is.
My Blog 
