We have and outer join between two tables - let's say TableA and TableB - where TableB currently have a filter in the Content definition in the BMM of the RPD. This filter is negating the outer join, which then behaves as a normal inner join. A SQL statement from this join looks like this:

SELECT * FROM TableA A
LEFT OUTER JOIN TableB B ON B.TableA_Wid = A.Row_Wid
WHERE B.Category = 'ASSESSMENT';

Is there a way to configure TableB, so the filter is part of the outer join instead? We would like a SQL statement from these tables to look like this:

SELECT * FROM TableA A
LEFT OUTER JOIN TableB B ON B.TableA_Wid = A.Row_Wid AND B.Category = 'ASSESSMENT';