Hi Fabiano, I was thinking more like this: 1. User wants bills from client x and program makes a select * from clients where name= x 2. Program displays x bills in some grid. 3. Later on, user wants x bills from march and I would like to make a query in program like this select * from lastResultSet where moth(bill_date) = 'march' of course, in this particular example, I could have made a query like select * from clients where name= x and month(bill_date)= 'march' but sometimes the second query is not added so easily, you would have to make some parsing to mix both queries. It would be a lot easier if there were some temporary result set and apply filters to this temporary. Regards, Hector Rios
________________________________ From: Fabiano <[email protected]> To: [email protected] Sent: Friday, September 21, 2012 1:26 PM Subject: RES: [firebird-support] How to make queries to a temporary result set Maybe: Select * from ( select * from table where field1 = 1 ) as FILTER Where FILTER.field2 = 2 Fabiano. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
