Difficult for help, can't figure out the idea, let's look at it

caboom04

There is a question, I don't understand, that is:
select company id, company name, sum (amount) as total from
(
                   select * from [1]
                   union all
                   select * from [2]
) t
There is no concept related to "request time" in this case.
and request time <(case when @enddate is null then request time + 1 else @enddate end)
and request time> (case when @startdate is null then request time-1 else @startdate end
Can it be added to this t-table, the younger brother does not yet understand

caboom04

There is a question, I don't understand, that is:
select company id, company name, sum (amount) as total from
(
                   select * from [1]
                   union all
                   select * from [2]
) t
There is no concept related to "request time" in this case.
and request time <(case when @enddate is null then request time + 1 else @enddate end)
and request time> (case when @startdate is null then request time-1 else @startdate end
Can it be added to this t-table, the younger brother does not yet understand

muxiaoke

There is a question, I don't understand, that is:
select company id, company name, sum (amount) as total from
(
                   select * from [1]
                   union all
                   select * from [2]
) t
There is no concept related to "request time" in this case.
and request time <(case when @enddate is null then request time + 1 else @enddate end)
and request time> (case when @startdate is null then request time-1 else @startdate end
Can it be added to this t-table, the younger brother does not yet understand

caboom04

Got it, thank you