aspose file tools*
The moose likes JDBC and the fly likes different between inner join and outer join in MS SQL2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "different between inner join and outer join in MS SQL2000" Watch "different between inner join and outer join in MS SQL2000" New topic
Author

different between inner join and outer join in MS SQL2000

Nakata kokuyo
Ranch Hand

Joined: Apr 13, 2005
Posts: 442
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

Joined: Dec 15, 2005
Posts: 333
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

Joined: Apr 13, 2005
Posts: 442
thks , stu derby
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: different between inner join and outer join in MS SQL2000