ZBlog学习笔记

/* SQL带出部门*/

select b.departmentname,a.departmentid from hrmresource a ,

 hrmdepartment b where a.departmentid  = b.id and a.id = 3

 /*--SQL带出岗位*/

select b.jobtitlename,a.jobtitle from hrmresource a ,

 hrmjobtitles b where a.jobtitle  = b.id and  a.id = 3

 /*-- SQL带出分部*/

 select b.subcompanyname,a.subcompanyid1 from hrmresource a left join

 HrmSubCompany b on a.subcompanyid1  = b.id where a.id = 3