Actually, two tables will not work before the RHS: "... LHS INNER JOIN X, Y RHS ON LHS.@idcol = RHS.@idcol" is not legal.