Thread: create query with date values

create query with date values

From
ourdiaspora
Date:
Recipients,

How to create a query such that when a date value is entered, the date may be associated with the result of another
query.

The scenario is that a date value is entered (the plan is these dates should be a separate table), then a query result
isjoined with the date value. 

Please advise the correct terminology for appropriate review of the manual.




Re: create query with date values

From
Ron
Date:
On 12/31/21 7:12 AM, ourdiaspora wrote:
Recipients,

How to create a query such that when a date value is entered, the date may be associated with the result of another query.

The scenario is that a date value is entered (the plan is these dates should be a separate table), then a query result is joined with the date value.

Please advise the correct terminology for appropriate review of the manual.

Maybe I misunderstand you, but it sounds like you are referring to an inner join (which is the standard way of joining):

SELECT .....
FROM SEPARATE_TABLE
   , MAIN_TABLE
WHERE SEPARATE_TABLE.SOME_DATE = MAIN_TABLE.OTHER_DATE
;

If this isn't what you mean, please clarify.

--
Angular momentum makes the world go 'round.

Re: create query with date values

From
"David G. Johnston"
Date:

On Friday, December 31, 2021, ourdiaspora <ourdiaspora@protonmail.com> wrote:
Recipients,

How to create a query such that when a date value is entered, the date may be associated with the result of another query.

The scenario is that a date value is entered (the plan is these dates should be a separate table), then a query result is joined with the date value.

Please advise the correct terminology for appropriate review of the manual.

You have normal queries, functions, and procedures.  I suppose a “prepared query” might also fit the bill.  Read up on those and, along with whatever application-level abstractions you choose to create, have tools for building queries.

David J.