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
    customer.CustomerCode=CustomerContact.CustomerCode.
    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.


    Thanks

    Nick
     
    nick, Mar 31, 2005
    #1
    1. Advertisements

  2. nick

    Salvador Guest

    Hi,

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

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