PL/SQL Not Exists

    select     user.id, user.name
     from     schema.table_users user
   where not exists ( select dept.kullanici_id
                  from schema.table_departments dept
                  where dept.user_id=user.id)
 order by user.id;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"