MS Sync Framework: How can I create Filter using two tables (with IN, JOIN) ?

See more:

synchronize

Using the new MS Sync Framework I could successfully setup sync with a filter clause for one table:
e.g.:

serverProvision.Tables["TICKETS"].AddFilterColumn("TICKETID");
serverProvision.Tables["TICKETS"].FilterClause = "[side].[TICKETID] = @ticketid";

But I want to combine the filter-clause with a second table so that only rows of Table1 are downloaded to client when value of column1 is in selected rows of Table2

instead of

... TICKETID = @ticketid

use

... WHERE TICKEID IN ( SELECT TICKETID FROM TASKS WHERE TASKS.EMPLOYE = @emplyoe_id )

Is this possible in Sync Framework or can I filter only by columns of the downloaded table only

Thanks for any hints!

added:

I did some workaround now (sync more stuff than needed, but limit by additoial columns)
- after reading many googled pages ... imo it is not possible to do cross filtering,
Only filter on multiple columns and combined filter clause on same table seems to be possible.
But brings up danger in databse mismatch (using duplicated fields etc)