logic and <

From: Greg (anonymous_at_discussions.microsoft.com)
Date: 04/30/04


Date: Thu, 29 Apr 2004 20:51:06 -0700

Hi

Im am trying to work out the following:
Employees have a base salary of 30,000, and for each years experience they get another 3000. However they cannot receive more than 150,000. How would I do that in a query.
Much appreciated