Board index » delphi » Query dependant on results from another query

chris ross

Delphi Developer
Tue, 21 Mar 2006 18:04:50 GMT

Query dependant on results from another query

I want to be able to obtain all the records that have not had an entry
in the last x days, however I seem to be able only to get those that
have had a new reord in the last x days.

Therefore I am thinking that I need to do a query where i get all the
policies that are not in the result set of my first query, but I have
forgotten how to do this query in a query.

Can anyone give me an example?

Ta.

 
jaso

Delphi Developer
Tue, 21 Mar 2006 19:07:30 GMT

Re:Query dependant on results from another query


Chris,
If I get what you are saying perhaps you want a query like this..
'select * from table where recordupdatedate < ' + (now - x);

???
Hope that helps,
Jason.

Quote
chris ross <ch...@tenerifeinsurance.biz> wrote:
>I want to be able to obtain all the records that have not had an entry
>in the last x days, however I seem to be able only to get those that
>have had a new reord in the last x days.

>Therefore I am thinking that I need to do a query where i get all the
>policies that are not in the result set of my first query, but I have
>forgotten how to do this query in a query.

>Can anyone give me an example?

>Ta.

Bill Tod

Delphi Developer
Tue, 21 Mar 2006 22:32:19 GMT

Re:Query dependant on results from another query


On Fri, 03 Oct 2003 12:04:50 +0200, chris ross

Quote
<ch...@tenerifeinsurance.biz> wrote:
>Can anyone give me an example?

Not without a clear explanation of the problem and the metadata of the
tables involved. Perhaps it would help if you showed us the query that
does not work.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. help: querying the results of a SQL Query...

2. Querying the results of a query

3. query on Query result without view

4. Query the result of a query in Delphi?

5. Is there a way to run a query against the result set another query

6. Query on a result on another query

7. To build a query by using the results of other queries

8. Querying the results of a query

9. How to Query the result of a Query?

10. Is is ImPossible Query to Result Query, Really?