Select queries with subquery


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 -

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

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

Thanks for reply.

How are your classes mapped? You can use a feature to remove duplicated values: Note that this is done at client side.