object pointers, joins and order by

[Danny Lewkin]

Hi List,

This query runs fine :

SELECT tbl_compcards.competence_descr, tbl_compcards.competence_name
FROM tbl_compcards INNER JOIN mm_compcards_course_module ON  
mm_compcards_course_module.objptr_compcard = tbl_compcards.RecID  
WHERE objptr_project = 1 ORDER BY tbl_compcards.competence_name;

But since I have an objectpointer 'objptr_compcard' in the table  
'mm_compcards_course_module', pointing to 'tbl_compcards', I would  
have liked to write the query using that objectpointer. So the query  
would be like this:

SELECT objptr_compcard->competence_name, objptr_compcard- 
 >competence_descr FROM mm_compcards_course_module WHERE  
objptr_project=1 ORDER BY objptr_compcard->competence_name;

So, I get an error message, telling me that I can not do an ORDER BY  
on objectpointers.
Why is this? I want to go the valentina-way ALL tha way, but feel  
restricted now. Is there a workaround except using inner joins? Is it  
usefull to put a featrue request into mantis for this, or will it  
never be possible??

Greetz,

Danny