You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
7 lines
456 B
Plaintext
7 lines
456 B
Plaintext
2 years ago
|
INSERT INTO HtmlLabelInfo ( indexid,labelname, languageid ) VALUES ( 10006035,'平行部门', 7 ),(10006035,'Parallel departments',8),(10006035,'平行部門',9)
|
||
|
|
|
||
|
|
|
||
|
|
select id,departmentname from hrmdepartment where supdepid=
|
||
|
|
(select d.supdepid from HrmResource r join hrmdepartment d on r.departmentid=d.id where r.id='8')
|
||
|
|
and subcompanyid1 = (select subcompanyid1 from HrmResource where id='8')
|
||
|
|
and id !=(select departmentid from HrmResource where id='8')
|