这个SQL语句怎么写,在线等待,谢谢了!

SQL> create table a (userid varchar2(2),funcid varchar2(2));

Table created.

SQL> create table b (funcid varchar2(2),funcname varchar2(10));

Table created.

SQL> insert into a values ('a','01');

1 row created.

SQL> insert into a values ('a','02');

1 row created.

SQL> insert into b values ('01','add');

1 row created.

SQL> insert into b values ('02','del');

1 row created.

SQL> insert into b values ('03','update');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from a;

US FU
-- --
a 01
a 02

SQL> select * from b;

FU FUNCNAME
-- ----------
01 add
02 del
03 update

SQL> select a.userid,(case when a.funcid=b.funcid then 'true' else 'false' end) flag,b.funcid,funcname from a,
b where b.funcid=a.funcid(+);

US FLAG FU FUNCNAME
-- ----- -- ----------
a true 01 add
a true 02 del
false 03 update

同一楼上的
select nvl(a.userid,'a')

select (case when a.usr_func_id=b.af_id and a.user_id=8
then 'true'
else 'false'
end) flag,
b.af_id,
b.af_func_name
from
re_wa_user_right a,
re_wa_adm_funclist b
where b.af_id=a.usr_func_id(+)
/

搞定了，谢谢各位，给分!