[firebird-support] SQL

[mohamed hamza medh...@hotmail.com [firebird-support]]

Hi All,

  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?

EXAMPLE

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  ) ;

Best Regards