inner join results

[User 13834889]

Hi, I have below query which giving 8 records. declare @t table (id int) declare @t2 table(id2 int) insert into @t values(1),(1),(1) insert into @t2 values(1),(1),(1) select t1.id from @t t1 inner join @t2 t2 on t1.id=t2.id2 I think we should get 9 records. Please help Thanks

[Richard Deeming]

That code produces 9 records here. There must be something else going on. Execute your query in a new SSMS query document. Try adding SET ROWCOUNT 0 at the top, just in case you've picked up some weird settings from somewhere.

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[Victor Nijegorodov]

I tested your script in SSMS-2017. It gives me 9 records. BTW, perhaps you should scroll the "result" window to see the last row?