select * from hr_employee he, ( select he.id id,rr.user_id uid,he.name_related as nam,ru.login login from hr_employee he inner join ( res_users ru inner join resource_resource rr on rr.user_id = ru.id and ru.id = CURRENT_USER_ID ) on he.resource_id = rr.id ) as t where he.parent_id=t.id
I want to make the above SQL statement record rule.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/31/13, 3:05 AM|
|Seen: 967 times|
|Last updated: 10/5/15, 2:47 AM|