jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Learning Joins Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Learning Joins" Watch "Learning Joins" New topic
Author

Learning Joins

prem arora
Ranch Hand

Joined: Jul 23, 2007
Posts: 33
Since 331 B.C., the different joins( INNER JOIN, OUTER...) are not clear to me and its generally very difficult to know before executing a query, what would be the output. What is the best way to understand and learn the joins. Does "HFSQL" put any light into it specifically or generally and make this ambiguous area any clearer?


SCJP 5.0<br />IBM Rational Rose 633<br />Target SCWCD....
Lynn Beighley
author
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
Prem,
I think the coverage of joins in this book is about the clearest that I've ever seen.


Lynn Beighley<br />Author, Head First SQL
prem arora
Ranch Hand

Joined: Jul 23, 2007
Posts: 33
Thanks Lynn,
I hope to go thru it as soon as possible.
Also, Have been going through www.scottberkun.com and you were correct, the essays, the ones I have read, are good, they certainly are. Thanks for the suggestion.
Good Luck..
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

Have been going through www.scottberkun.com and you were correct, the essays, the ones I have read, are good, they certainly are. Thanks for the suggestion.
Indeed. What a treasure.
Maybe the best advise I've ever received on the ranch.


OCUP UML fundamental and ITIL foundation
youtube channel
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Learning Joins
 
Similar Threads
Can we execute sql query with outer join in hibernate
deadlock
Expert knowledge needed: loops in sql queries
Regular query vs JDBC Programming?
T-Systems Pune