How can I create this filter?

Select * from (select * from Table1 where Field1=1) As FilterdTable Right Outer Join Table2 On Table1.Field3=Table2.Field3

Notice that the filter of table1 can not be placed in where clause. because the right join imposes some null values to result set and filtering the left table after join (in where clause) would eliminate some vital records.

does this sql produce the same results

Select * from Table1 Right Outer Join Table2 On Table1.Field3=Table2.Field3 and Table1.Field1=1

if so then use the _Relation.CustomFilter _property to add new PredicateExpression(Table1Entity.Field1 == 1);

It solves my problem,Thanks.