Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

different between inner join and outer join in MS SQL2000

 
Nakata kokuyo
Ranch Hand
Posts: 471
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, good day, can someone pls guide me the different between inner join and outer join , when i should them ? any sample will highly appreciated , thank you very much for guidance
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nothing to do with a particular database; inner and outer joins are features of standard SQL, or any language that implements the relational theory of E.F. Codd.

Here's a good page with examples.
http://en.wikipedia.org/wiki/Join_%28SQL%29
 
Nakata kokuyo
Ranch Hand
Posts: 471
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thks , stu derby
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic