how can I join following two SQL into one? The data is in the same Avaya CMS Informix table.
1. data needed from yesterday 1/26/2022 b/w 19:00 and 2400
2.data needed form today 1/27/2022 b/w 0000 and 07:00
select row_date, starttime,starttime_utc, split,acdcalls from hsplit where split=11 and row_date>=TODAY and starttime<=700
Database selected.
row_date starttime starttime_utc split acdcalls
01/27/2022 0 1643259600 11 0
01/27/2022 30 1643261400 11 0
01/27/2022 100 1643263200 11 0
01/27/2022 130 1643265000 11 0
01/27/2022 200 1643266800 11 0
01/27/2022 230 1643268600 11 0
01/27/2022 300 1643270400 11 0
01/27/2022 330 1643272200 11 0
01/27/2022 400 1643274000 11 0
01/27/2022 430 1643275800 11 0
01/27/2022 500 1643277600 11 0
01/27/2022 530 1643279400 11 0
01/27/2022 600 1643281200 11 0
01/27/2022 630 1643283000 11 0
01/27/2022 700 1643284800 11 0
15 row(s) retrieved.
Database closed.
select row_date, starttime,starttime_utc, split,acdcalls from hsplit where split=11 and row_date>=TODAY-1 and starttime>=1900
!
Database selected.
row_date starttime starttime_utc split acdcalls
01/26/2022 1900 1643241600 11 0
01/26/2022 1930 1643243400 11 0
01/26/2022 2000 1643245200 11 0
01/26/2022 2030 1643247000 11 0
01/26/2022 2100 1643248800 11 0
01/26/2022 2130 1643250600 11 0
01/26/2022 2200 1643252400 11 0
01/26/2022 2230 1643254200 11 0
01/26/2022 2300 1643256000 11 0
01/26/2022 2330 1643257800 11 0
10 row(s) retrieved.
1. data needed from yesterday 1/26/2022 b/w 19:00 and 2400
2.data needed form today 1/27/2022 b/w 0000 and 07:00
select row_date, starttime,starttime_utc, split,acdcalls from hsplit where split=11 and row_date>=TODAY and starttime<=700
Database selected.
row_date starttime starttime_utc split acdcalls
01/27/2022 0 1643259600 11 0
01/27/2022 30 1643261400 11 0
01/27/2022 100 1643263200 11 0
01/27/2022 130 1643265000 11 0
01/27/2022 200 1643266800 11 0
01/27/2022 230 1643268600 11 0
01/27/2022 300 1643270400 11 0
01/27/2022 330 1643272200 11 0
01/27/2022 400 1643274000 11 0
01/27/2022 430 1643275800 11 0
01/27/2022 500 1643277600 11 0
01/27/2022 530 1643279400 11 0
01/27/2022 600 1643281200 11 0
01/27/2022 630 1643283000 11 0
01/27/2022 700 1643284800 11 0
15 row(s) retrieved.
Database closed.
select row_date, starttime,starttime_utc, split,acdcalls from hsplit where split=11 and row_date>=TODAY-1 and starttime>=1900
!
Database selected.
row_date starttime starttime_utc split acdcalls
01/26/2022 1900 1643241600 11 0
01/26/2022 1930 1643243400 11 0
01/26/2022 2000 1643245200 11 0
01/26/2022 2030 1643247000 11 0
01/26/2022 2100 1643248800 11 0
01/26/2022 2130 1643250600 11 0
01/26/2022 2200 1643252400 11 0
01/26/2022 2230 1643254200 11 0
01/26/2022 2300 1643256000 11 0
01/26/2022 2330 1643257800 11 0
10 row(s) retrieved.