RECORDS MANAGEMENT UNIT

HUMAN RESOURCES

  • For Authorised use only
  • Error Query [SELECT DISTINCT user.PK_USER_ID, user.Username, user.PAssword, user.FK_PERSON_ID, user.fk_role_id, menu.PK_Menu_ID, menu.Menu_Name, menu.href, menu.level, menu.fk_menu_id, menu.seq, menu.parent, role.role_id, role.role_name, roleassign.fk_Menu_ID, roleassign.fk_role_id FROM role INNER JOIN (user INNER JOIN (menu INNER JOIN roleassign ON menu.PK_Menu_ID = roleassign.fk_Menu_ID) ON user.fk_role_id = roleassign.fk_role_id) ON role.role_id = user.fk_role_id WHERE level = 0 AND PK_Menu_ID in (159,160,161,9,19,20,1) AND user.PK_USER_ID = ORDER BY seq]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY seq' at line 1