query shows record 2 times RSS

• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  query shows record 2 times

  Dec 30, 2012 02:58 PM|LINK

  i am using this to fill gridview

  but problem is that it shows each record two times , why ?

  Select tbluser.fullname, tbluser.email, tblJobAdv.advtitle, tblPersonalInfo.country,
   tblPersonalInfo.city, tblJobOffer.digitalsignature
   from tblUser
   left join tblPersonalInfo
   ON tblUser.userid = tblPersonalInfo.userid
   left join tblApplication
   On tblApplication.userid = tblUser.userid
   left join tblJobAdv
   On tblJobAdv.advid = tblApplication.advid
   left join tblJobOffer
   On tblUser.userid = tblJobOffer.userid
   where tblJobAdv.userId IN (select userid from tblUser where email = 'h@y.com')

  
  
  

  Hunain Hafeez
• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: query shows record 2 times

  Dec 30, 2012 03:15 PM|LINK

  use distint 

  Select distinct tbluser.fullname, tbluser.email, tblJobAdv.advtitle, tblPersonalInfo.country,
  tblPersonalInfo.city, tblJobOffer.digitalsignature
  from tblUser
  left join tblPersonalInfo
  ON tblUser.userid = tblPersonalInfo.userid
  left join tblApplication
  On tblApplication.userid = tblUser.userid
  left join tblJobAdv
  On tblJobAdv.advid = tblApplication.advid
  left join tblJobOffer
  On tblUser.userid = tblJobOffer.userid
  where tblJobAdv.userId IN (select userid from tblUser where email = 'h@y.com')

  Hunain Hafeez
  • Edited by Hunain Hafeez on Dec 30, 2012 03:15 PM
  • Edited by decker dong - msft on Dec 31, 2012 12:01 AM
  • Marked as answer by decker dong - msft on Dec 31, 2012 12:01 AM
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: query shows record 2 times

  Dec 31, 2012 12:02 AM|LINK

  Hi,

  I come here to check whether your problem is solved or not……，

  If yes，please mark it as an answer or just feel free to feedback.