wood burning stoves 2.0*
The moose likes JDBC and the fly likes HF - SQL Inner and Outer Joins Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HF - SQL Inner and Outer Joins" Watch "HF - SQL Inner and Outer Joins" New topic

HF - SQL Inner and Outer Joins

Mark Beavis
Ranch Hand

Joined: Apr 07, 2005
Posts: 43
Does HF SQL have a good coverage of INNER and OUTER joins, and some example queries?

In my experience people (including me) usually find these concepts quite confusing when learning SQL.
Ken Boyd
Ranch Hand

Joined: Dec 10, 2003
Posts: 329
absolutely essential with real time example

Lynn Beighley
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
Inner and outer joins are covered in quite a bit of detail. I tried to make them very clear, and I believe I succeeded.

Lynn Beighley<br />Author, Head First SQL
It is sorta covered in the JavaRanch Style Guide.
subject: HF - SQL Inner and Outer Joins
Similar Threads
Difference between inner and outer joins
Options for a Subquery
JPQL Query question
Old style SQL vs new style SQL
can anyone tell me how many joins are in SQL.AND how many are in Oracle.?