SQL JOINS - SQL Server Forums

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 2000 Forums

Transact-SQL (2000)

SQL JOINS

Author

Topic

v_chendur
Starting Member

1 Post

Posted - 2009-05-20 : 22:45:54

Which on is better:
table1 OUTER JOIN table1 on a.id = b.id

or

table1,table2 where a.id = b.id

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2009-05-20 : 22:48:10

See SQL best practices. "table1 OUTER JOIN table1 on a.id = b.id" is much prefer.

For fast result follow this...
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

Want Philippines to become 1st World COuntry? Go for World War 3...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources