locked
how to join null with null value RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Actaully My joi like this

    prov.Client=wfb.Client 

     

    in that Prov.cleint is null also wfb.client is null  and based on that I get output wfb.rowid but currently i checked that because of null I am missing couple of rowid

    Friday, November 18, 2011 5:35 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    HI aminesh !

    The simpler would be to use below;

    ISNULL(prov.Client,'')=ISNULL(wfb.Client,'')


    Please let me know if this doesn’t work for you. Hope I have answered you correctly.
     
    Thanks,
    Hasham

    • Proposed as answer by skc_chat Friday, November 18, 2011 5:44 AM
    • Marked as answer by Aminesh Friday, November 18, 2011 5:45 AM
    Friday, November 18, 2011 5:40 AM
    Answerer