create query with date values
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.
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.
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.