difference between subquery and join

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

difference between subquery and join

Author

Topic

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-02-13 : 13:21:03

hi,

1)what is the difference between subquery and join?
1) what is left outer join?
2) what is inner join?

Desikankannan

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-13 : 13:23:48

see

http://www.w3schools.com/Sql/sql_join.asp

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources