I am new to sql, I am coming from Xbase system .
I want to know if it 's possible to execute query using last query result?
1 select * from persons where state='CA'
2 select * from persons where age> 18 but we have to use the result of 1
I DO NOT WANT TO DO AN AND ( STATE = 'CA' AND AGE > 18 ) ;