left outer join...

• tran008

  Ten Centuries

  Points: 1002

  More actions

  February 6, 2004 at 7:52 am

  #107624

  Hi all,

  I have a table with 538790 row count, but if I do an 'left outer join' with another table, I received more row count. Can any one explain why I'm getting this?

  thanks

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 6, 2004 at 8:06 am

  #493085

  Can you post the statement?

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• tran008

  Ten Centuries

  Points: 1002

  More actions

  February 6, 2004 at 8:26 am

  #493091

  select count (*) from order1

  result=538790

  select a.orderid, b.orderid from order1 a left outer join order_old b on

  a.orderid=b.orderid order by b.orderid

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 6, 2004 at 8:52 am

  #493096

  You have Duplicates OrderIds on your "order_old" table or on your "order1" table

   HTH

   

  
  * Noel

• Johan Bijnens

  SSC Guru

  Points: 135376

  More actions

  February 6, 2004 at 9:03 am

  #493099

  noeld is probably right.

  If you have a sql2k sp3a and a multiprocessor-box, you need a hotfix for the count(*). That could also be a reason.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me