February 6, 2004 at 7:52 am
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
February 6, 2004 at 8:06 am
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]
February 6, 2004 at 8:26 am
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
February 6, 2004 at 8:52 am
You have Duplicates OrderIds on your "order_old" table or on your "order1" table
HTH
* Noel
February 6, 2004 at 9:03 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply