usage of join, right join,left join in db2 ... and more

ushaveginati · New User Joined: 26 Nov 2010 Posts: 1 Location: pune

what is the usages of join, right join,left join in db2? What is the main difference between right join and left join?
can i get the syntaxes of the above/

enrico-sorichetti · Posted: Fri Nov 26, 2010 1:36 pm

don' t You think it would be smarter to use a more meaningful title for Your questions ?

at the top of the page there is a link to the manuals

for a more exhaustive manual reading You can start here
www-03.ibm.com/systems/z/os/zos/bkserv/index.html
and choose from all the IBM manuals
for db2 related manuals start from
www-03.ibm.com/systems/z/os/zos/bkserv/zapplsbooks.html

a good place for additional info is also
www.redbooks.ibm.com/

and use the search facility to find out more