join filter and row filter , please help

Discussion in 'microsoft.public.sqlserver.replication' started by nick, Mar 31, 2005.

  1. nick

    nick Guest

    Hi :

    i have two tables, parent table is customer, children table is
    customercontact and they link by customercode.

    fistly, i set join filter as
    then i set row filter in customer table with customer= HOST_NAME()
    and i set row filter in customerContact table with isExpired=0.

    my questions is that seems row filter in customerContact table
    doesn't really work?

    just wondering is that right way to handle this situation? set row
    filter at both parent and children table.


    nick, Mar 31, 2005
    1. Advertisements

  2. nick

    Salvador Guest


    SELECT *
    LEFT JOIN CUSTOMERCHILD c ON m.CustomerCode = c.CustomerCode AND c.ISExpired
    WHERE m.Customer = HostName()

    Hope this helps
    Salvador, Mar 31, 2005
    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.