title: SELECT clause with three tables together
body: <p>Example, having these 3 tables</p>
  
  <p>DEPARTMENT</p>
  
  <pre><code>//DEPARTMENT
  DNAME       BUDGET      CHAIRMAN
  ----------------------------------
  RESEARCH     2000         JOHN
     IT        3000          MAY
   SCIENCE     5000         KING
  </code></pre>
  
  <p>PROJECT</p>
  
  <pre><code>//PROJECT
  P#     TITLE     BUDGET    STARTD          ENDD
  ----------------------------------------------------
  1      COMPUTING   200     13-10-1993      13-11-1993
  2       CODING     300     15-10-1993      15-12-1993
  3      SEARCHING   188     07-07-1995      08-08-1995
  </code></pre>
  
  <p>DP &lt;--Assume constraint references done already, just didn't show the coding here</p>
  
  <pre><code>//DP
  DNAME        P#
  ----------------
  RESEARCH      1
    IT          2
  RESEARCH      3
  </code></pre>
  
  <p>SO when i run this statement</p>
  
  <pre><code>SELECT d.DNAME,d.BUDGET,d.CHAIRMAN,p.TITLE,p.BUDGET,p.STARTD,p.ENDD 
       FROM DEPARTMENT d INNER JOIN PROJECT p 
       INNER JOIN DP dp ON DP.P#=p.P#;
  </code></pre>
  
  <p>but show some errors. want to get output like this:
  Only display those involved in the project tables</p>
  
  <pre><code>DNAME    BUDGET   CHAIRMAN     TITLE      BUDGET     STARTD        ENDD
  ---------------------------------------------------------------------------
  RESEARCH  2000     JOHN       COMPUTING    200       13-10-1993  13-11-1993
  RESEARCH  2000     JOHN       SEARCHING    188       07-07-1995  08-08-1995
     IT     3000      MAY         CODING     300       15-10-1993  15-12-1993
  </code></pre>