What I meant is to use the Filter tab to input your conditions, not the Join tab. The Filter conditions are used to build the WHERE clause.

The Example column (under the Filter tab) can contain any expression, so, fields too.

Vlad

>I could do this through an SQL statement, but I'm trying to set it up as a view inside the database, can I put in my own code there?, if I add a view inside the database I get the view designer and AFIK, the SQL statement is read only.