joins examples on multiple tables

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
sasanka
Member
Posts: 19
Joined: Wed Dec 29, 2010 11:37 pm
Location: hyderabad

joins examples on multiple tables

Post by sasanka » Sat Jan 08, 2011 1:27 am

hi,
can u take 5 tables with primary keys and foreign keys and explain
how to select data from them using joins

like if we want to take 5 table data we cant take it directly we have to involve all other 4 tables

pls explain this with an example it will be useful for many of them.

Gyani
Member
Posts: 7
Joined: Sat Jan 08, 2011 1:28 pm
Location: HYB

Post by Gyani » Sun Jan 23, 2011 10:45 am

Hi Sasanka,

its very gud question. I can suggest u go through online tutorial.
For eg. there is another option to select data from 5 diffrent tables without joins which s nested queries. u ll learn such smal small things...

http://www.sql-tutorial.net/SQL-JOIN.asp

Thanks,
Gyani.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others