Join Filter works on only one of the tables in the join

Discussion in 'microsoft.public.sqlserver.replication' started by Tommy, Dec 8, 2004.

  1. Tommy

    Tommy Guest

    We have two tables: tblAdj_Hdr and tblAdj_Dtl. I have them in a merge
    replication with a static filter on tblAdj_Hdr where the COMP field is 0 and
    then we have a join filter between the two tables on a field ADJID. When some
    data is entered on the subscriber (Laptops using MSDE) and then replication
    is triggered the records in the tblAdj_Detail that were joined to a record in
    tblAdj_Hdr that the COMP field was 0 are the only ones left on the
    subscriber, but ALL the records in tblAdj_Hdr are still present. Any ideas?

    Tommy Norman
    Tommy, Dec 8, 2004
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.