> On Aug 28, 2019, at 12:54 AM, Kjell Rilbe kjell.ri...@marknadsinformation..se > [firebird-support] <firebird-support@yahoogroups.com> wrote: > > Den 2019-08-05 kl. 13:20, skrev 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 ) ; > > > First: Why not use and AND? That would be the most natural solution.
And will perform best. If both terms are indexed, Firebird will use both indexes. > > Second: No, a plain sequence of SQL queries do not support that. But you > can put them in a stored procedure or an "execute block" statement ... Would a CTE work? Good luck, Ann