title: Is it possible to select multiple tables to view as one big table in SQL?
body: <p>so I'm using the DB2 scripting from IBM i / System i (and old version where Collection is used instead of Schema) </p>
  
  <p>and I noticed that its becoming tedious to having to keep typing</p>
  
  <p>"select * from mycollectionName.whatever" for each table.</p>
  
  <p>is there anyway I can select from multiple tables and have it display all the information in one big table?</p>
  
  <p>example:</p>
  
  <pre><code>CREATE TABLE UMALIK8.ADULTS (
  ADULT_NUM VARCHAR (10) NOT NULL CONSTRAINT UMALIK8.ADULTS_PK PRIMARY KEY,
  ADULT_L_NAME CHAR (50) NOT NULL,
  ADULT_F_NAME CHAR (50) NOT NULL,
  RELATIONSHIP CHAR (30) NOT NULL,
  STREET VARCHAR (50) NOT NULL,
  APT_NUM VARCHAR (10),
  CITY CHAR (50) NOT NULL,
  POSTAL_CODE VARCHAR (6) NOT NULL,
  HOMEPHONE VARCHAR (20) NOT NULL,
  WORKPHONE VARCHAR (20));
  
  CREATE TABLE UMALIK8.EMPLOYEE (
  EMP_NUM VARCHAR (10) NOT NULL,
  EMP_L_NAME CHAR (50) NOT NULL,
  EMP_F_NAME CHAR (50) NOT NULL,
  PAYRATE DECIMAL (10, 2) NOT NULL,
  POSNCODE VARCHAR (10) NOT NULL,
  HIREDATE DATE NOT NULL,
  CONSTRAINT UMALIK8.EMPLOYEE_PK PRIMARY KEY (EMP_NUM),
  CONSTRAINT UMALIK8.EMPLOYEE_FK FOREIGN KEY (POSNCODE)
  REFERENCES UMALIK8.POSITION(POSNCODE));
  </code></pre>
  
  <p>I have these two tables, and I've created my Insert statement for them.</p>
  
  <p>Now I want to select them and view them across a big table, instead of having to switch tabs (in Run Script from System i Navigator).</p>
  
  <p>Is this possible? Is it better to make individual select statement for each table i create?</p>
  
  <p>Would I do something along the lines of this? </p>
  
  <pre><code>Select * From umalik8.Adults, umalik8.Employee
      WHERE umalik8.Adults = umalik8.Employee
  </code></pre>
  
  <p><em><strong>EDIT</em></strong></p>
  
  <p>Okay, so I kinda got lucky and tried this</p>
  
  <pre><code>SELECT TABLE_NAME 
      FROM UMALIK8.SYSTABLES;     
  
  
  SELECT COLUMN_NAME, TABLE_NAME
      FROM UMALIK8.syscolumns;   
  </code></pre>
  
  <p>AND it almost worked...it shows me all the tables and all the columns in each tab, EXCEPT what was inserted (the record).</p>
  
  <p>All help is greatly appreciated!</p>