Select queries with subquery

BIZ TMS Aurelius
1

Hello.

Sorry for my poor English.

I need retrieve result with this SQL query:

  "SELECT * FROM Members WHERE id IN (SELECT id FROM AllowedMemebers);"

Maybe i can use this:

  Manager.Find<TMembers>.Add(TLinq.Sql('id IN (SELECT id FROM AllowedMemebers)'));

But i dont try this because IN operator is not recomended.

I prefer something like this - http://dev.mysql.com/doc/refman/5.1/en/rewriting-subqueries.html

  "SELECT DISTINCT Members.* FROM Members, AllowedMemebers WHERE Members.id=AllowedMemebers.id;"

But i don't have any idea what i do this in your aurelius.

Thanks for reply.

2

How are your classes mapped? You can use a feature to remove duplicated values: http://www.tmssoftware.com.br/aurelius/doc/web/index.html?removing_duplicated_objects.htm. Note that this is done at client side.