From: tamer23@myrealbox.com   
      
   Hi!   
   I have problems creating joins between tables and to limit rows for a   
   specified clolumn. I have 2 tables!   
      
   employees   
   departments   
      
   I face the problems with the GROUP BY clause and i don't get it handled   
   solving that problem. Neither with oracle sql or SQL1999 syntax!   
      
   Oracle SQL:   
      
   SELECT   
   dep.department_name as "Name",   
   dep.location_id as "Location",   
   emp.salary AS "Salary"   
   FROM employees emp, departments dep   
   WHERE (emp.department_id = dep.department_id)   
   GROUP BY dep.department_name;   
      
   SQL1999:   
      
   SELECT   
   department_name as "Name",   
   location_id as "Location",   
   salary AS "Salary"   
   FROM employees emp   
   JOIN departments dep   
   USING(department_id)   
   GROUP BY department_id;   
      
      
   for any help   
      
      
   Thank you   
      
      
   Tamer   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)