View retrieving incorrect values

• omkar.k28

  Newbie

  Points: 8

  More actions

  March 27, 2012 at 12:54 am

  #259198

  Hi

  i have view (join of multiple tables)

  i trying to querying view it is giving wrong result ?

  any on help me on this ?

• Pradyothana Shastry

  SSCertifiable

  Points: 5211

  More actions

  March 27, 2012 at 1:05 am

  #1464735

  Just check which view and what is your expected values from your query ...and in that view or objects which you are joining has required data 🙂

  
  - Pradyothana http://www.msqlserver.com

• Nakul Vachhrajani

  SSChampion

  Points: 10294

  More actions

  March 27, 2012 at 1:07 am

  #1464736

  This needs more information. Please refer the post: Forum Etiquette: How to post data/code on a forum to get the best help[/url] that describes the bare minimum requirements before we can starting helping you.

  Thanks & Regards,
  Nakul Vachhrajani.
  http://nakulvachhrajani.com

  Follow me on
  Twitter: @sqltwins

• kutti609

  SSC Rookie

  Points: 29

  More actions

  March 27, 2012 at 3:04 am

  #1464799

  Hi,

  Please post the View which is returning wrong result .

  Thanks,

  Kuttikrishnan.P

• Nakul Vachhrajani

  SSChampion

  Points: 10294

  More actions

  March 27, 2012 at 3:08 am

  #1464804

  kutti609 (3/27/2012)

  ---

  Hi,

  Please post the View which is returning wrong result .

  Thanks,

  Kuttikrishnan.P

  And some test data showing what's wrong.

  Thanks & Regards,
  Nakul Vachhrajani.
  http://nakulvachhrajani.com

  Follow me on
  Twitter: @sqltwins