Test Page
Menus: GREG SELECT mg.menu_group_id, mg.menu_group_short_desc, mg.menu_group_long_desc, mg.sort_seq as MG_sort_seq, mi.menu_item_id, mi.menu_description, mi.menu_action, mi.sort_seq as mi_sort_seq /* create two independent key joins, then non-equijoin them together */ FROM (brb.menu_items mi KEY JOIN brb.menu_groups mg ) JOIN (brb.users U key join brb.security_levels SL ) on MI.MIN_SECURITY_LEVEL_ID <= U.MAX_SECURITY_LEVEL_ID WHERE user_name = '#ARGUMENTS.USERNAME#' ORDER BY mg_sort_seq, mi_sort_seq, menu_description SELECT count(*) as valCount /* create two independent key joins, then non-equijoin them together */ FROM (brb.menu_items mi KEY JOIN brb.menu_groups mg ) JOIN (brb.users U key join brb.security_levels SL ) on MI.MIN_SECURITY_LEVEL_ID <= U.MAX_SECURITY_LEVEL_ID WHERE user_name = '#ARGUMENTS.USERNAME#' AND menu_action = '#ARGUMENTS.MenuAction#'