You could always try the LIMIT keyword :) select a.college, a.state, a.cd <http://a.cd/>, b.rep from a, b where a.state = "al" and a.cd <http://a.cd/> = "3" or a.state = "az" and a.cd <http://a.cd/> = "1" and a.state = b.state and a.cd <http://a.cd/> = b.cd <http://b.cd/> LIMIT 50 -- Joseph Crawford Jr. Codebowl Solutions codebowl@xxxxxxxxx
