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-- AL District: 1 Member Rank--1 Member Total Actions-- 4 MemberNo-- 68
AL 1 1 4 68
Record Read-- State-- AL District: 2 Member Rank--1 Member Total Actions-- 4 MemberNo-- 49
AL 2 1 4 49
Record Read-- State-- AL District: 3 Member Rank--1 Member Total Actions-- 4 MemberNo-- 48
AL 3 1 4 48
Record Read-- State-- AL District: 3 Member Rank--1 Member Total Actions-- 2 MemberNo-- 38
Record Read-- State-- AL District: 5 Member Rank--1 Member Total Actions-- 4 MemberNo-- 54
AL 5 1 4 54
Record Read-- State-- AR District: 18 Member Rank--6 Member Total Actions-- 15 MemberNo-- 27
AR 18 6 15 27
Record Read-- State-- AR District: 18 Member Rank--6 Member Total Actions-- 2 MemberNo-- 43
Record Read-- State-- AR District: 19 Member Rank--1 Member Total Actions-- 9 MemberNo-- 71
AR 19 1 9 71
Record Read-- State-- AR District: 19 Member Rank--1 Member Total Actions-- 4 MemberNo-- 70
Record Read-- State-- AZ District: 11 Member Rank--1 Member Total Actions-- 5 MemberNo-- 33
AZ 11 1 5 33
Record Read-- State-- AZ District: 13 Member Rank--4 Member Total Actions-- 10 MemberNo-- 34
AZ 13 4 10 34
Record Read-- State-- CA District: 28 Member Rank--1 Member Total Actions-- 3 MemberNo-- 32
CA 28 1 3 32
Record Read-- State-- CA District: 29 Member Rank--1 Member Total Actions-- 9 MemberNo-- 51
CA 29 1 9 51
Record Read-- State-- CA District: 29 Member Rank--1 Member Total Actions-- 5 MemberNo-- 60
Record Read-- State-- CA District: 30 Member Rank--1 Member Total Actions-- 4 MemberNo-- 72
CA 30 1 4 72
Record Read-- State-- CO District: 78 Member Rank--1 Member Total Actions-- 3 MemberNo-- 37
CO 78 1 3 37
Record Read-- State-- CO District: 79 Member Rank--1 Member Total Actions-- 4 MemberNo-- 45
CO 79 1 4 45
Record Read-- State-- CO District: 80 Member Rank--1 Member Total Actions-- 5 MemberNo-- 47
CO 80 1 5 47
Record Read-- State-- CT District: 82 Member Rank--1 Member Total Actions-- 6 MemberNo-- 30
CT 82 1 6 30
Record Read-- State-- CT District: 83 Member Rank--1 Member Total Actions-- 4 MemberNo-- 58
CT 83 1 4 58
Record Read-- State-- CT District: 86 Member Rank--1 Member Total Actions-- 7 MemberNo-- 42
CT 86 1 7 42
Record Read-- State-- DE District: 87 Member Rank--3 Member Total Actions-- 10 MemberNo-- 31
DE 87 3 10 31
Record Read-- State-- ID District: 130 Member Rank--1 Member Total Actions-- 2 MemberNo-- 35
ID 130 1 2 35
Record Read-- State-- IN District: 152 Member Rank--1 Member Total Actions-- MemberNo-- 29
IN 152 1 29
Record Read-- State-- IN District: 157 Member Rank--1 Member Total Actions-- 6 MemberNo-- 59
IN 157 1 6 59
Record Read-- State-- KY District: 172 Member Rank--1 Member Total Actions-- 10 MemberNo-- 61
KY 172 1 10 61
Record Read-- State-- MA District: 197 Member Rank--1 Member Total Actions-- 4 MemberNo-- 46
MA 197 1 4 46
Record Read-- State-- NY District: 277 Member Rank--1 Member Total Actions-- 4 MemberNo-- 73
NY 277 1 4 73
Record Read-- State-- PA District: 337 Member Rank--1 Member Total Actions-- 11 MemberNo-- 63
PA 337 1 11 63
Record Read-- State-- PA District: 351 Member Rank--11 Member Total Actions-- 97 MemberNo-- 1
PA 351 11 97 1
Record Read-- State-- PA District: 351 Member Rank--8 Member Total Actions-- 3 MemberNo-- 36
Record Read-- State-- PA District: 351 Member Rank--7 Member Total Actions-- 7 MemberNo-- 9
Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 7 MemberNo-- 50
Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 7 MemberNo-- 52
Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 6 MemberNo-- 41
Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- 5 MemberNo-- 44
Record Read-- State-- PA District: 351 Member Rank--1 Member Total Actions-- MemberNo-- 28