SQL Server Forums - select query Inner join vs left join

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

select query Inner join vs left join

New Topic

Reply to Topic

Printer Friendly

Author

Topic

cplusplus
Constraint Violating Yak Guru

483 Posts

Posted - 02/17/2013 : 13:47:11

I am making an inner join in etl job , first table has 7000 rows second table has 12000 rows.

because of inner join i am getting the result output exact 7000 rows, which is first table match count.

How can i get 12000 rows as my result can i just do left join, will it produce 12000 rows as my final result?

This is based on an ETL job, this one element is part of a bigger job which takes almost 7 hrs.

Just would like to have the details then will make the necessary changes.

Thanks a lot for the helpful info.

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts

Posted - 02/17/2013 : 14:06:42

you need to do a left join with bigger table on left side of the join to get 12000 rows

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cplusplus
Constraint Violating Yak Guru

483 Posts

Posted - 02/17/2013 : 14:28:08

Thks Visakh, you are an amazing guy

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts

Posted - 02/17/2013 : 23:22:06

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.