SELECT DISTINCT VOTES.CONGRESS, VOTES.MEMBER_ID, 
VOTES.ROLLCALL, 
VOTES.VOTE, ROLLREQ.PRES_POS, ROLLREQ.SUPPORTED, 
ROLLREQ.VOTETYPE, PARTY.PARTY, ISSUE.CLAUSEN
FROM ROLLREQ, VOTES, PARTY, ISSUE
WHERE (ROLLREQ.CONGRESS=93
 AND VOTES.CHAMBER_CLASS=3
 AND ROLLREQ.CHAMBER='H'
 AND ISSUE.CHAMBER='H'
 AND ISSUE.ROLLCALL=ROLLREQ.ROLLCALL-10)
 AND  ((VOTES.CONGRESS=ROLLREQ.CONGRESS)
 AND (VOTES.ROLLCALL=ROLLREQ.ROLLCALL)
 AND (PARTY.CONGRESS=VOTES.CONGRESS)
 AND (PARTY.MEMBER_ID=VOTES.MEMBER_ID)
 AND (ISSUE.CONGRESS=ROLLREQ.CONGRESS))
ORDER BY VOTES.MEMBER_ID ASC