So I first had these commands: create table blah (b INTEGER, c INTEGER); insert into blah values(400,300); insert into blah values(360,250); select a,max(b-a) from blah where c=a and a > 200 and a < 500;
That didn't work: 'a' doesn't exist. So I looked in the help and changed the last line to include '(select 300) as a'. That still didn't let me do what I really wanted to do; use 'a' in the max function. What's the right way to do that? And how do I simply return a range of numbers with a select statement? Thanks. ______________________________ Brannon King ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯