DB2 graphic  QMF Version 8

Present data dependent on non-presented data

A query using multiple tables can present data from one table that is dependent on data in another table. For example, using the example element _D in the DEPT column of Q.STAFF and the DEPTNUMB column of Q.ORG, you can present the ID, name, and department of only those employees who are located in Dallas.

When you run this query:

Q.STAFF | ID | NAME | DEPT  |
--------+----+------+-------|
P.      |    |      | _D    |
 
 
Q.ORG | DEPTNUMB | LOCATION |
------+----------+----------|
      | _D       | DALLAS   |

QMF produces this report:

    ID  NAME       DEPT
------  ---------  ----
   140  FRAYE        51
   150  WILLIAMS     51
   220  SMITH        51
   230  LUNDQUIST    51
   250  WHEELER      51


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004