Snapshot replication

I want to replicate some data from one database to other database. The data to be replicated need to be filtered based on various conditions involving many tables Example

select * from a,b,c where a.x=b.x and b.x=c.x and a.y='vivek'

So I need to specify joins. Further I have to replicate many tables based on various conditions. How to do it. Is there any way to specify a DTS package while configuring publisher? I can have all the conditions in a DTS package and specify the same in while configuring publisher.
Server version MS SQL 2000
Or can you suggest me an alternative method.
Other relevant information
Replication to be done at the end of the day
Users at remote database should be able to perform operations on the database.
Regards
Vivek

I think that you'd have to:
create a table in the source database
populate it with the data you want each night
replicate this source table on a nightly basis

I don't think that there is a way to replicate a join or the data within a view...

another option might be to replicate the three tables and a view definition...

Cheers
Twan