如何使用Castle ActiveRecord在两个表之间进行联接

如果别的什么都不起作用,坚持总是起作用的。我知道怎么做,很简单:

DetachedCriteria SubmissionsQuery = DetachedCriteria.For<Submission>();

SubmissionsQuery.Add(Restrictions.Eq("Kind", SubmissionKind.Question));
SubmissionsQuery.SetProjection(Projections.Property("Id"));

DetachedCriteria Filter = DetachedCriteria.For<Answers>();
Filter.Add(Subqueries.PropertyIn("CommonId", SubmissionsQuery));
Filter.SetFirstResult(Start);
Filter.SetMaxResults (Size);

ActiveRecordMediator<Answers>.FindAll(Filter);

我希望下一个人能发现这个有用。