Thanks, that did what I needed! You are right, part of Condition1 is the relation between the tables, but it also includes conditions on UserTable and DataTable (it's a conjunction of three sub-conditions). adding the join and a where clause after it took care of all of them.