6 Replies Latest reply: Mar 19, 2012 4:25 AM by Przemysław Wojda RSS

    How to get many tables from one select?

    Przemysław Wojda

      Hi All,

       

      how could I change the below example into one SELECT to get three tables?

       

       

      Department_1:
      SELECT Name, Department FROM Employees WHERE Department = 1;
      
      Department_2:
      SELECT Name, Department FROM Employees WHERE Department = 2;
      
      Department_3:
      SELECT Name, Department FROM Employees WHERE Department = 3;
      

       

      Thank you,

      Przemek