How to use the wizard to replicate 2 tables into one using a join?

I have one app with one database, and I need to make a replication of some of those tables, and also include one new table which is a join of more than one of those tables.

I tried transaction replication, but the filter for the tables only allows me to modify the 'where' clause.

Anybody can h开发者_开发技巧elp me with this?

I'd replicate the two tables in question as-is, then create a view on the subscriber to represent your desired join.