select a.f_user_id,a.F_user_name from t_User a,t_Role b,t_User_Role c where a.F_User_Name=c.F_User_Name and b.F_Role_Name=c.F_Role_Name and b.F_Role_Name='asdf'
select a.f_user_id,a.F_user_name from t_User a,t_Role b,t_User_Role c where a.F_User_Name=c.F_User_Name and b.F_Role_Name=c.F_Role_Name and b.F_Role_Name= ....
where a.F_User_Name=c.F_User_Name and b.F_Role_Name=c.F_Role_Name
and b.F_Role_Name='asdf'
where a.F_User_Name=c.F_User_Name and b.F_Role_Name=c.F_Role_Name
and b.F_Role_Name= ....