SQL语句转换
破碎的脸 2011-04-12 12:57:59 string sql = string.Format(@"select u.usertruename,r.roledesc,mu.* from userInfo u
inner join RoleInfo r on r.roleID=u.roleId
inner join RoleRight m on m.roleId=r.roleId
inner join MenuInfo mu on mu.menuid=m.menuid
where u.userName='{0}' and mu.MenuParentID={1}", name, parentId);
这条SQL要怎么写才能在ACCESSS里运行?