谁能写这条语句啊？

[webdesigning]

SELECT S_SYS_MOD.*, S_MOD_ROLE.ROLECODE FROM S_MOD_ROLE RIGHT OUTER JOIN S_SYS_MOD ON S_MOD_ROLE.MODULECODE = S_SYS_MOD.CODE and ROLECODE=" & rolecode & " order by S_SYS_MOD.CODE

Access数据库不支持这条语句，谁能写出相应功能在Access数据库上运行的sql语句？

[webdesigning]

to cjf1009(农民程序员):

你的那条是不等效的，再帮我想想啊

[cjf1009]

SELECT S_SYS_MOD.*, S_MOD_ROLE.ROLECODE FROM S_MOD_ROLE,S_SYS_MOD where S_MOD_ROLE.MODULECODE = S_SYS_MOD.CODE and ROLECODE=" & rolecode & " order by S_SYS_MOD.CODE

[efei]

SELECT S_SYS_MOD.*, S_MOD_ROLE.ROLECODE FROM S_MOD_ROLE RIGHT OUTER JOIN S_SYS_MOD ON S_MOD_ROLE.MODULECODE = S_SYS_MOD.CODE WHERE ROLECODE=" & rolecode & " order by S_SYS_MOD.CODE