title: Sybase, create a new table from a select statment from multiple tables
body: <p>I have two tables in Sybase:</p>
  
  <p><code>TABLE1</code>: holds the department data and emp_id associated with departments:</p>
  
  <pre><code>Dept_Id     Emp_id1   Emp_id2   Emp_id3
  -------     -------   -------   -------
  DEP1          11        22        33
  </code></pre>
  
  <p><code>TABLE2</code>: holds the Emp_Id and multiple Address_Id associated with employee:</p>
  
  <pre><code>Emp_Id     Add_Id
  ------    --------
  11         street1
  11         street2
  11         street3
  22         mountRoad1
  22         mountRoad2
  33         PetersRoad
  </code></pre>
  
  <p>I want to join these two tables and insert the following results into a new table:</p>
  
  <pre><code>Dept_Id   Emp_Id   Add_Id
  -------   ------   ------
  DEP1       11       street1
  DEP1       11       street2
  DEP1       11       street3
  DEP1       22       mountRoad1
  DEP1       22       mountRoad2
  DEP1       33       PetersRoad
  </code></pre>
  
  <p>How can I achieve this using single SQL query?</p>