multiple implicit joins and explicit joins in a query [closed]

multiple implicit joins and explicit joins in a query [closed]

References

Reference NO 1

http://stackoverflow.com/questions/15199801/multiple-implicit-joins-and-explicit-joins-in-a-query

Reference NO 2

http://stackoverflow.com/questions/9411453/what-is-the-difference-between-implicit-explicit-joins

Reference NO 3

http://en.wikipedia.org/wiki/Join_(SQL)

Reference NO 4

http://docs.jboss.org/hibernate/orm/3.5/reference/en-US/html/queryhql.html

Reference NO 5

https://support.ca.com/cadocs/0/CA%20Chorus%2003%200%2000-ENU/Bookshelf_Files/HTML/Performance%20Handbook%20for%20DB2/Encouraging_Index_Access_and_Table_Join.html

Reference NO 6

http://community.qlikview.com/servlet/JiveServlet/previewBody/3412-102-3-3894/Joins%20and%20Lookups.pdf

Reference NO 7

http://www.dbspecialists.com/files/presentations/semijoins.html

Reference NO 8

http://mhjewel.wordpress.com/2008/02/04/how-does-sql-join-clause-works-part-%E2%80%93i-a-little-bit-theoretical/