how to display count values in join

• dastagiri16

  Hall of Fame

  Points: 3544

  More actions

  September 29, 2011 at 10:07 am

  #248993

  hi i wrote query like this..

  select COUNT(u.userid) from users u inner join

  status s on

  (u.userid=s.mtid) or (u.userid=s.editorid)

  please find attchment..

  my query displaying count =3(here duplicates diplaying)

  but i need result only count=2(101,102 without duplicates..)

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  September 29, 2011 at 10:11 am

  #1388486

  Pretty simple:

  select COUNT(DISTINCT u.userid) from users u inner join

  status s on

  (u.userid=s.mtid) or (u.userid=s.editorid)

• dastagiri16

  Hall of Fame

  Points: 3544

  More actions

  September 29, 2011 at 10:29 am

  #1388497

  thanks for helping ...it is working....