SELECT * FROM tb_hr_user thu WHERE thu.c_no IN (SELECT c_userno FROM tb_user_post WHERE ( c_post_guid IN (/*下屬信息*/ SELECT c_guid FROM tb_post WHERE c_x_higher_post IN (SELECT c_post_guid FROM tb_user_post tup WHERE c_userno = '"+Parameters!用戶編號(hào)_.Value+"') OR c_y_higher_post IN (SELECT c_post_guid FROM tb_user_post tup WHERE c_userno = '"+Parameters!用戶編號(hào)_.Value+"') OR c_next_higher_post IN (SELECT c_post_guid FROM tb_user_post tup WHERE c_userno = '"+Parameters!用戶編號(hào)_.Value+"')) OR c_userno = '"+Parameters!用戶編號(hào)_.Value+"' /*看到自己的信息*/ ))

可以限制報(bào)表中，當(dāng)前用戶所看到的下屬人員相關(guān)的信息。