Max Rank Table Deleted select Member.state, Member.district, Member.memberRank, Member.memberTotalActions, Member.memberno
FROM Member left Join Ranks on Member.memberRank = Ranks.RankNo wHERE Member.state >'A' and Member.district >'0'
order by Member.state asc, Member.district asc, Member.memberRank desc, Member.memberTotalActions DESC, Member.memberno asc Resource id #4
Record Read-- State-- PA District: 337 Member Rank--1 Member Total Actions-- 10 MemberNo-- 2 PA 337 1
10 2Record Read-- State-- PA District: 337 Member Rank--1 Member Total Actions-- 10 MemberNo-- 2 Record Read-- State-- PA District: 337 Member Rank--1 Member Total Actions-- 10 MemberNo-- 2 Record Read-- State-- PA District: 337 Member Rank--1 Member Total Actions-- 10 MemberNo-- 2 Record Read-- State-- PA District: 337 Member Rank--1 Member Total Actions-- 10 MemberNo-- 2 Record Read-- State-- PA District: 337 Member Rank--1 Member Total Actions-- 10 MemberNo-- 2 Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 10 MemberNo-- 1 PA 351 1
10 1Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 10 MemberNo-- 1 Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 10 MemberNo-- 1 Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 10 MemberNo-- 1 Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 10 MemberNo-- 1 Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 10 MemberNo-- 1