select aliasname.listelement from entity is working fine for me with out any porblems...

But if i am writing :-

select aliasname.string, aliasname.listelement from entity I am getting missign expression error ...i dont want to get the entire entity as it is too heavy. can some one suggest me a way at the earliest.

I think you can join the two related tables and project the attributes that you want to select.

i.e.


select aliasname.string, aliasname2.attribute from entity aliasname join aliasname.listelement aliasname2;