try this: select revenue, bonuses from bonuses group by some_field having max(revenue)< 8411 ps: some_field should be replaced by the proper field that you choose to use. hope it helps. -- An. Henry Ponce Linux Registered User # 303567 NYC